Power BI Desktop Query Parameters, Part 1, Introduction
One of the coolest features added to the April 2016 release of Power BI Desktop is “Query Parameters”. With Query…
Search
Results for “query parameters”
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…
Quick Tips: Renaming All Tables’ Columns in One Go in Power Query
I previously wrote a blog post explaining how to rename all columns in a table in one go with Power…
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…