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.…
Archive
Category: Power Query
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…
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…