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.
Published on:
Learn moreRelated posts
Modern Visual Tooltips in Power BI (Generally Available)
Power BI’s latest update introduces an enhancement to how users interact with reports with the general availability of modern visual tooltips....
Calculate(), DAX Fusion And Filters On 0 In Power BI
Here’s a fun DAX performance tip that I found this week. Do you have measures that use Calculate() with a filter on a numeric column? Is...
Power BI Report Server January 2026 Feature Summary
Welcome to January 2026 Power BI Report Server feature summary! These updates bring new capabilities and enhancements across Reporting and Vis...
Power BI Update - January 2026
Power BI January 2026 Feature Summary
IMPORTANT NOTE: The January Power BI Desktop release began rolling out today (1/20). Updates may take time to reflect in the desktop release. ...