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[…]
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[…]
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[…]
Microsoft Fabric offers an end-to-end SaaS analytics solution; however, the world is using all kinds of data sources in its implementation. Mirroring is a new functionality in Fabric that allows customers to keep their data wherever they are, but then they can use Fabric analytics solutions with the same speed and performance as if their Read more about Mirroring Snowflake in Fabric: Supercharged Analytics at No Extra Costs[…]
If you ever want to have a general report for sales for all countries, and then you want every morning the report to be sent (as PDF or PowerPoint alongside the link to the report) to representatives of each country, the report with the data filtered for their country only, then Dynamic Subscription in Power Read more about Power BI Dynamic Subscription: Send Scheduled Report Filtered for Everyone’s Data Automatically[…]