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[…]
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[…]
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[…]
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[…]
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[…]
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[…]
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[…]
The Lakehouse or Warehouse comes with a default Power BI Sematic model, which can be used for reporting and analytics. However, you can also build and use a customized semantic model. There are significant differences when using the semantic model in real-world analytics projects. In this article, I’ll explain the difference between these two, which Read more about Power BI Default Semantic Model or Custom; A Guide for Using in Fabric Environment[…]
The Button Slicer is one of the recent visuals that is very helpful in taking your report layout and visualization to the next level. Although this visual has been available for some time, many are still unfamiliar with its features. In this article and video, I’ll take you through this visual, its features, and how Read more about Button Slicer Enhances the Power BI Visualization[…]
There has been a lot of hype recently about Generative AI and Copilot in Microsoft. Microsoft Fabric incorporates many of those features, and one of the areas it has been added to is the Dataflow Gen2 in Microsoft Fabric, or we can also call it Power Query in Power BI Service Dataflows. In this article Read more about Copilot in Power Query in Power BI Service and Microsoft Fabric Dataflow Gen2[…]