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
I previously wrote a blog post explaining how to rename all columns in a table in one go with Power Query. One of my visitors raised a question in the comments about the possibility to rename all columns from all tables in one go. Interestingly enough, one of my customers had a similar requirement. So … Continue reading Quick Tips: Renaming All Tables’ Columns in One Go in Power Query
Update September 2022: I wrote a new blog post covering the same scenario in Excel 365. 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 … Continue reading Dynamically Passing Parameters to a SQL Stored Procedure from PowerPivot Using VBA
Today I want to explain how you can pass parameters to a SQL Server stored procedure. I myself was looking for a way to pass parameters to a SQL Server stored proc from Power Query. I spent a lot of time to search for a good article over the internet that explains how I could … Continue reading Power Query and SQL Server Stored Procedures
