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
Introducing user-defined functions (UDFs) in DAX
Power BI Update - September 2025
Power BI September 2025 Feature Summary
The Power BI September 2025 Feature Summary introduces updates for users and coincides with FabCon Vienna! This release introduces several key...
How To Get The Details Of Power BI Operations Seen In The Capacity Metrics App
It’s the week of Fabcon Europe and you’re about to be overwhelmed with new Fabric feature announcements. However there is a new bl...
Deprecation of Power BI Integration within SharePoint Lists and Libraries
Today, we are announcing the retirement of the Power BI integration within SharePoint lists and libraries. This change impacts customers who c...
AI and Agentic Development for Power BI
New Fabric Tenant Setting: “Set alert” Button Visibility for Power BI Users
A new Microsoft Fabric tenant setting will make the “Set alert” button visible to all Power BI web users, enabling them to create Fabric Activ...
What Happens When Power BI Direct Lake Semantic Models Hit Guardrails?
Direct Lake mode in Power BI allows you to build semantic models on very large volumes of data, but because it is still an in-memory database ...