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
Power BI October 2025 Feature Summary
This month’s update brings exciting opportunities for learning and community engagement, including the upcoming Fabric Skills Fest and t...
Power BI Report Server September 2025 Feature Summary
PBIRS September 2025 Feature Summary
Automating Power BI Semantic Model Security with Fabric Semantic Link
You may be using standardized solutions like Fabric Unified Admin Monitoring (FUAM) or any other templated solution that comes with a semantic...
First Look At Fabric Graph: Analysing Power BI Import Mode Refresh Job Graphs
The new Fabric Graph database is now rolling out now and should be available to everyone within the next few weeks if you can’t see it a...
Empowering our customers to shape the future of data connectivity in Power BI and Microsoft Fabric
Discover how Microsoft is transforming data connectivity in Power BI and Microsoft Fabric with a community-driven approach. Learn how you can ...
Understanding Power BI Totals: The Math, the Model, and the Misconceptions
The long-running debate around how Power BI calculates totals in tables and matrices has been part of the community conversation for years. Gr...