SCD Type 2 in Microsoft Fabric and Power BI

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[…]
The post SCD Type 2 in Microsoft Fabric and Power BI appeared first on RADACAD.
Published on:
Learn moreRelated posts
Convert tabular data to crosstab – Power Query
Convert tabular data to crosstab – Power Query. Let us understand this simple but useful task in Microsoft Excel. Download sample file R...
How to Rebind a Power BI Report to a different Semantic Model using Power BI Studio
The default option to rebind a Power BI report is to use the Power BI REST API. This works well, but for a lot of people this can be quite int...
New mapping and location analytics capabilities in Microsoft Power BI
The Microsoft Azure Maps visual in Microsoft Power BI enables all Power BI users to visualize and analyze their data on maps to uncover patter...