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 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. Maybe it is time to look at it again. … Continue reading Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query

The post Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query appeared first on BI Insight.