Build Your First Report in Microsoft Power BI Designer Part 1, Basics
First of all I would like to briefly explain Microsoft Power BI Designer. Then we’ll see how easy we can…
Archive
Category: Power BI
Dynamically Passing Parameters to a SQL Stored Procedure from PowerPivot Using VBA
Update September 2022: I wrote a new blog post covering the same scenario in Excel 365. In this post, I…
Resolving Format Cells Change after Refreshing Data Sources in Power Query
In this post I want to share my experience with refreshing data in Power Query and the way it affects…
Power Query and SQL Server Stored Procedures
Today I want to explain how you can pass parameters to a SQL Server stored procedure. I myself was looking…