Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1
I explained what SCD means in a Business Intelligence solution in my previous post. We also discussed that while we do not expect to handle SCD2 in a Power BI implementation, we can handle scenarios similar to SCD1. In this post, I explain how to do so. Scenario We have a retail company selling products. … Continue reading Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1
The post Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1 appeared first on BI Insight.
Published on:
Learn moreWe can help you with Slowly Changing Dimension (SCD) in Power BI, Part 2, Implementing SCD 1
If you want help implementing, troubleshooting, or improving this product, contact us and we’ll point you in the right direction.
Related posts
From D365 Business Central to Power BI: Transform Your Sales Data into Insights
Are you a Power BI developer who has suddenly been asked to build reports on top of Dynamics 365 Business Central sales data? The post From D3...
Microsoft Fabric Apps: Business vs Data Apps – What’s the Difference?
Have you ever thought about using Microsoft Fabric Apps for something other than building a traditional business application? What if you alre...
Agentic AI in Power BI and Fabric, Part 5: Building a Power BI Theme Audit Agent
In Part 4 of this series, I used the Power BI report management and authoring skills to audit report themes across Fabric workspaces. The work...
Building a Microsoft Fabric App with GitHub Copilot, Without Knowing How to Code
Taking the Ask, Plan, Human in the Loop and Agent workflow out of the diagrams and into a real project: building an AdventureWorks-style Micro...
Agentic AI in Power BI and Fabric, Part 4: From Skills to an Agentic Report Theme Audit Workflow
In Part 1, I went through the concepts and terminology behind agentic AI, things like agents, tools, skills, MCP, guardrails, and Human i...
Agentic AI in Power BI and Fabric, Part 3: Agentic AI in Action with GitHub Copilot and Power BI Modeling MCP
In the previous blog, I covered the practical setup for agentic AI workflows with VS Code, GitHub Copilot, and safe local MCP testing. I…...
Agentic AI in Power BI and Fabric, Part 2: Getting Started with VS Code, GitHub Copilot, and Safe MCP Setup
A Personal Note Before We Continue Before I continue this series, I want to briefly share why it took me so long to publish this second blog. ...
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...
Sharing Power BI Reports with External Users – Part 3: Sensitivity Labels, Encryption, and Secure Sharing
In Part two of this series, we walked through how to configure your Microsoft Fabric environment to securely share Power BI reports with ...