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
Agentic AI in Power BI and Fabric, Part 4: From Skills to an Agentic Report Theme Audit Workflow
In Part 1, I went through the concepts and terminology behind agentic AI, things like agents, tools, skills, MCP, guardrails, and Human i...
Agentic AI in Power BI and Fabric, Part 3: Agentic AI in Action with GitHub Copilot and Power BI Modeling MCP
In the previous blog, I covered the practical setup for agentic AI workflows with VS Code, GitHub Copilot, and safe local MCP testing. I…...
Agentic AI in Power BI and Fabric, Part 2: Getting Started with VS Code, GitHub Copilot, and Safe MCP Setup
A Personal Note Before We Continue Before I continue this series, I want to briefly share why it took me so long to publish this second blog. ...
Understanding Power BI Totals: The Math, the Model, and the Misconceptions
The long-running debate around how Power BI calculates totals in tables and matrices has been part of the community conversation for years. Gr...
Sharing Power BI Reports with External Users – Part 3: Sensitivity Labels, Encryption, and Secure Sharing
In Part two of this series, we walked through how to configure your Microsoft Fabric environment to securely share Power BI reports with ...
Sharing Power BI Reports with External Users – Part 2: Hands-On Guide to Setup and Sharing
In Part one of this series, we covered the foundational concepts behind sharing Power BI reports with external users. We explained why th...
Sharing Power BI Reports with External Users – Part 1: Understanding the Problem and Core Concepts
Sharing Power BI reports with external users is a common but often misunderstood scenario. While it may seem simple on the surface, doing it p...
Microsoft Fabric: Revealing Cost-Saving Results from Automating Pause & Resume Fabric Capacity
If you work in data and analytics, particularly within the Microsoft Data Platform, you have likely heard of Microsoft Fabric and its many cap...
Microsoft Fabric: Unlocking the Secrets to Mastering Shared Semantic Models – Part 2 – Implementation
This blog series complements a YouTube tutorial I published earlier this month, where I quickly covered the scenario and implementation of sha...