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
Category: DAX
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…
Thin Reports, Report Level Measures vs Data Model Measures
The previous post explained what Thin reports are, why we should care and how we can create them. This post…
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…