1 day agoPower BI — show and hide measures on slicerIn some cases you want to see all the measures on your visualizations. But in some instances you want to manipulate the visibility of your calculations. Today I tell you how you can show or hide measures depending on your needs. First step is creating standard measures: Next step…Power Bi2 min read
Jun 10Microsoft Planner - a short introWhen you run or are a part of a medium/large project. Then you use tools like Jira, Azure DevOps to organize a team work, tasks, deadlines, etc. They are great, versatile applications with a lot of functionalities. But what if you are a part of a smaller project and you…Microsoft Planner3 min read
Jun 10BULK INSERT — dynamic SQLSometimes you have to import many CSV files into a database. You can do it with SSIS for example. But there is more convenient and flexible way to realise it. To import one file you can use BULK INSERT BULK INSERT [dbo].[GHCN] FROM ‘D:\New\2020.csv’ …Sql Server1 min read
May 13Azure SQL Database — dynamic data maskingWhen you want to restrict access to object like column. Sometimes better idea is to mask data and keep the column available. Azure accomodates the expectations and has implemented this mechanism. Go to the Dynamic Data Masking option. On the right you can see Recommended fields to mask or add…Azure Sql Database2 min read
Apr 29Azure SQL Database — add Azure Active Directory usersWhen you create Azure SQL database, during provisioning you specifiy SQL Server authentication adminstrator account.Azure2 min readAzure SQL Database — add Azure Active Directory usersWhen you create Azure SQL database, during provisioning you specifiy SQL Server authentication adminstrator account.----
Apr 15Power BI — streaming dataflows and Azure Event HubToday, I show you how to use streaming dataflows along with Azure Event Hub. So that, let’s create Azure Event Hub namespace— it is an event hubs namespace.Power Bi3 min read
Apr 1Power Automate for Power BI visualizationOne of useful functionalities of Power Platform is Power Automate. For instance you can create and invoke automated flows inside Power BI through Power Automate for Power BI visualization. Visual is avilable out of the box.Power Bi3 min read
Mar 18Power BI — Object Level SecurityEveryone who works with Power BI has heard or used Row Level Security. But not everyone knows that Power BI offers OLS — Object Level Security. If you want to restrict an access to partucular object like table, column. You can use this functionality. As of today you have to…Power Bi3 min read
Mar 4Power BI — backup and restore datasetsToday I show you, how you can create backups of your datasets. In order to do this you need ADLS (Azure Data Lake Storage) connected to Power BI Service on workspce or tenant level. So that, first point is to create Data Lake Storage. …Power Bi3 min read
Feb 18Power BI , Power Automate— auto refresh dataset after dataflowToday I want to show you how to implement auto dataset refresh after dataflow is refreshed. On order to this we use Power Automate. Let’s say, after “Iowa_Liquor_Sales” dataflow is refreshed we want to refresh the dataset automatically.Power Automate2 min read
