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…
Archive
Tag: M
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…
Thin Reports, Real-world Challenges
I previously explained in a blog post what thin reports are and why we should care about them. I also…
Business Intelligence Components and How They Relate to Power BI
When I decided to write this blog post, I thought it would be a good idea to learn a bit…