Tag: Power BI from Rookie to Rock Star

Power BI Aggregations Step 3: Configure Aggregation Functions and Test Aggregations in Action

Posted on by Reza Rad

Aggregation can speed up the performance of DirectQuery sourced tables significantly. To use it, firstly, you need to create an aggregation table. Secondly, you must set up proper storage modes for tables in the model. Finally, you have to configure the aggregation functions, which I will explain in this post. You can learn about aggregation Read more about Power BI Aggregations Step 3: Configure Aggregation Functions and Test Aggregations in Action[…]

Control the Execution Order and Output State in Fabric Data Pipeline

Posted on by Reza Rad

In Microsoft Fabric, the Data Factory is the workload for ETL and data integration, and the Data Pipeline is a component in that workload for orchestrating the execution flow. There are activities in the pipeline, and you can define in which order you want the activities to run. In this article and video, you will Read more about Control the Execution Order and Output State in Fabric Data Pipeline[…]

Refresh Power BI Semantic Model After Dataflow Automatically

Posted on by Reza Rad

Although this seems to be a simple thing to do, it is not a function that you can turn on or off. If you have a Dataflow that does the ETL and transforms and prepares the data, then to get the most up-to-date data into the report, you will need to refresh the Power BI Read more about Refresh Power BI Semantic Model After Dataflow Automatically[…]

Where to Start Microsoft Fabric as a Power BI Developer

Posted on by Reza Rad

One of the questions I often get these days is what are the benefits of Microsoft Fabric for Power BI users and developers. Questions like: “If I am not a data engineer or database developer, what are the use cases for Fabric for me?” or “What is in Fabric that I can leverage in my Read more about Where to Start Microsoft Fabric as a Power BI Developer[…]

Microsoft Certification Exams for Power BI and Fabric

Posted on by Reza Rad

If you want to get Microsoft certifications in the Fabric and Power BI space, there have been some changes in the past few years, especially with the changes in technology. In this blog and video, I’ll explain the current certifications in this area and what is covered in each. Video Why certifications? The first question Read more about Microsoft Certification Exams for Power BI and Fabric[…]

Migrate Power BI Dataflow Gen1 to Fabric Dataflow Gen2

Posted on by Reza Rad

Unfortunately, there isn’t a migration tool to convert your Power BI dataflow (gen1) to Microsoft Fabric dataflow (gen2). If you have Fabric capacity licenses, it just makes sense to do that migration because Dataflow Gen2 gives you data destinations into four destinations, which we don’t have in Dataflow Gen1. However, converting Gen1 to Gen2 isn’t Read more about Migrate Power BI Dataflow Gen1 to Fabric Dataflow Gen2[…]

REFRAME in Power BI Direct Lake

Posted on by Reza Rad

Power BI offers a new type of connection to Microsoft Fabric Lakehouse or Warehouse, called Direct Lake. The Direct Lake connection acts like DirectQuery and won’t need the data to be refreshed. However, the Power BI semantic model has refresh settings that can be turned on or off. In this article and video, you will Read more about REFRAME in Power BI Direct Lake[…]

Microsoft Fabric Glossary

Posted on by Reza Rad

There are a lot of similar terminologies and words when working with Fabric. We have Data Lake, Delta Lake, OneLake, and Lakehouse, and the list continues. I found it confusing for some to understand the differences between them. Although explaining these terms and their differences requires many different blog articles, having one place for a Read more about Microsoft Fabric Glossary[…]

SCD Type 2 in Microsoft Fabric and Power BI

Posted on by Reza Rad

In the previous article, I explained SCD (Slowly Changing Dimension) and its different types. In this article, I’ll show you how to implement SCD Type 2 (one of the most common types) using Microsoft Fabric and Power BI. This article includes using Lakehouse, Dataflow, Warehouse, Data Pipeline, SQL Stored Procedures, Power BI Semantic model, and Read more about SCD Type 2 in Microsoft Fabric and Power BI[…]

SCD: Slowly Changing Dimension, an Ultimate Guide

Posted on by Reza Rad

If you want to use Power BI, Microsoft Fabric, or any other data analytics tools, one of the key concepts to understand when working with a data warehouse system is the SCD (Slowly Changing Dimension). I will do this in a series of at least two articles. The first one (this one) will be on Read more about SCD: Slowly Changing Dimension, an Ultimate Guide[…]