Tag: Power BI

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[…]

Roles in a Data Analytics Team

Posted on by Reza Rad

In the previous article and video, I explained the important factors in having a successful data analytics team. One of those aspects is the team, the people, and their roles. In this article and video, I will explain the roles involved in the data analytics project and the types of tasks and requirements for each Read more about Roles in a Data Analytics Team[…]

Building a Data Analytics Team in this golden era of technology

Posted on by Reza Rad

Recently, I did a presentation at a conference, and the topic was non-technical, unlike many other presentations that I do. I thought it would be helpful for you all to know about it, as I spent some time and gathered some information about it combined with the experiences I had with some of my customers. Read more about Building a Data Analytics Team in this golden era of technology[…]

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[…]