An Easy Way for SSAS Batch Processing
Batch processing is available in Analysis Services. Which means we can send multiple processing commands to the server in just a…
Archive
Category: SQL Server
How To Implement a Composite Key In SSAS Tabular Model
As you might know SSAS tabular models do not support composite keys so you always must have just one column…
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…
Power Query and SQL Server Stored Procedures
Today I want to explain how you can pass parameters to a SQL Server stored procedure. I myself was looking…