Author: Mohan

Power BI Tabular Model Development tips

Power Query 1. Import or DirectQuery: Before your start developing the Tabular model, decide which data Connectivity mode suits your requirement. Read through the Microsoft documentation to understand the differences. Tip: DirectQuery mode can be changed into Import mode. However, the vice versa is not possible. 2. Disable auto date/time option: In Power BI Desktop, … Continue reading Power BI Tabular Model Development tips →

Copying data between Azure SQL databases using Azure Data Factory

In this article we will look at the steps involved in copying the data between two Azure databases using Azure Data Factory (ADF). Below are the steps involved in copying the data between two SQL databases using ADF. Create the linked service connections for the source and destination databasesCreate the input and output datasets from … Continue reading Copying data between Azure SQL databases using Azure Data Factory →

Most common methods to Filter the Power BI visualization

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. This post will discuss on the five most common methods to filter the Power BI visualization. For the demonstration, I have created one bar chart which displays Sales Amount by Product Category, one pie chart which is … Continue reading Most common methods to Filter the Power BI visualization →

Edit Interactions between Power BI visualizations

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. To demonstrate on how to control the interactions between two visualizations, I have created one bar chart which displays Sales Amount by Product Category and the other visualization is a pie chart, which is distributed according to … Continue reading Edit Interactions between Power BI visualizations →

DAX formula to obtain the count from SCD type-2 dimension records

Data source used for this post is the ‘Reseller Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server data warehouse. The ‘DimEmployee’ table in the data mart is clearly a SCD type-2 dimension, which means any update to the employee record is created as a new row with a new start date and the old employee … Continue reading DAX formula to obtain the count from SCD type-2 dimension records →

Customer retention over the years using DAX in Power BI

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. In this post, we will write and use DAX formulas to get the customer retention count when compared with last year and when compared with all the previous years. In addition, we will also look at testing … Continue reading Customer retention over the years using DAX in Power BI →

Ranking using DAX in Power BI

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. In this example, let’s look at ranking Countries and States individually according to the sales and then ranking Country and State fields when grouped together. For ranking, RANKX function is being used. RANKX function helps to provide … Continue reading Ranking using DAX in Power BI →

Color-code Visualizations using Grouping in Power BI

Data source used for this post is the ‘Internet Sales’ data mart of the ‘AdventureWorksDW2017´ SQL server database. Grouping clearly helps to better visualize and analyze our data. In this example, we will look at grouping the field values and use them to format the color of the visualizations. Let’s look at the steps involved … Continue reading Color-code Visualizations using Grouping in Power BI →