Endorsement in Power BI, Part 1, The Basics
As you may already know, Power BI is not a report-authoring tool only. Indeed, it is much more than that.…
Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query
In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure…
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…
Slowly Changing Dimension (SCD) in Power BI, Part 1, Introduction to SCD
Slowly changing dimension (SCD) is a data warehousing concept coined by the amazing Ralph Kimball. The SCD concept deals with…