Archive

Tag: PowerPivot and SQL Stored Procedure

DAX September 22, 2022 9 min read

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…

Power BI September 22, 2014 6 min read

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…