Adding Weather Forecast in Power BI using Azure Map

Azure Maps is a Microsoft technology that has a lot of cool features. Somewhat unexpectedly I discovered that along with purely mapping stuff it also provides functionality to acquire weather forecast data using REST API as outlined here. The detailed process is detailed in the video below, but I will highlight the key steps in … Continue reading Adding Weather Forecast in Power BI using Azure Map

How to Display Multiple Rows in a Single Cell of a Matrix or a Table

How can I condense multiple rows into a single cell in a Matrix or a Table? https://youtu.be/bjCclP7aTCQ Obviously, it is easy to display all details like you see below: But what if for every product I just want to know what countries it is selling in and what channels are used? Like how it is … Continue reading How to Display Multiple Rows in a Single Cell of a Matrix or a Table

What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)

Unfortunately, it does happen… You have just added a new calculation group/calculation item to your model and all of the sudden, some of the visuals on your report stop working. Usually, the main reason behind is some sort of invalid DAX in your calculation group. However, sometimes this might happen even if on a surface … Continue reading What to Do When Calculation Groups Break Your Measures (PowerBI Tutorial)

Taking another look at ALL() and ALLSELECTED() Functions

I have a video that takes another look at All() and AllSelected() functions. I start by talking about the flow of filters in the model. The direction of the arrow in the relationship between Fact and Dimension matters. With this background, I talk about using All() and AllSelected() function on Dimension table and compare it … Continue reading Taking another look at ALL() and ALLSELECTED() Functions

How to Deploy Azure Data Factory (ADF) from Dev to QA using Devops

Just wanted to do a quick video to cover the process of deploying ADF artifacts from Development environment to higher environments like QA, etc. these are the basic steps to get it done (please watch the video for detailed instructions) https://youtu.be/7fsIwWheyDk Create a new project in Devops if there is no project set up alreadyMake … Continue reading How to Deploy Azure Data Factory (ADF) from Dev to QA using Devops

Incrementally Load New Files in Azure Data Factory by Looking Up Latest Modified Date in Destination Folder

This is a common business scenario, but it turns out that you have to do quite a bit of work in Azure Data factory to make it work. So the goal is to take a look at the destination folder, find the file with the latest modified date, and then use that date as the … Continue reading Incrementally Load New Files in Azure Data Factory by Looking Up Latest Modified Date in Destination Folder