passing-parameters-to-a-sql-stored-procedure-from-powerpivot-dynamically-using-vba 
BI Insight
SEPTEMBER 21, 2014
In this post I express an easy way to refresh a PowerPivot model dynamically based on SQL Server Stored Procedures. Let’s start with SQL Server Management Studio (SSMS) 2012 and use Adventure Works 2012 database. Run the following script to see the results in SSMS: exec [dbo].[uspGetBillOfMaterials]
BI Insight
SEPTEMBER 21, 2014
In this post I express an easy way to refresh a PowerPivot model dynamically based on SQL Server Stored Procedures. Let’s start with SQL Server Management Studio (SSMS) 2012 and use Adventure Works 2012 database. Run the following script to see the results in SSMS: exec [dbo].[uspGetBillOfMaterials]
BI Insight
SEPTEMBER 22, 2022
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 was a real lifesaver. It perhaps still is for many of us. But frankly, I even forgot how to write VBA.
Expert insights. Personalized for you.
52 
Let's personalize your content