All posts tagged "Dynamic PowerPivot Connection"

Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query

[ad_1] In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure using VBA. Back then, VBA...