Datatype Conversion in Power Query Affects Data Modeling in Power BI
In my consulting experience working with customers using Power BI, many challenges that Power BI developers face are due to…
Archive
Category: DAX
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…
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…