What is new for BI in Excel 2016
It’s been awhile that we are waiting for a sensible improvements in Microsoft self-service BI. The good news is that…
Archive
Category: Power Pivot
Dynamically Passing Parameters to a SQL Stored Procedure from PowerPivot Using VBA
Update September 2022: I wrote a new blog post covering the same scenario in Excel 365. In this post, I…