Role-playing Dimension in SSAS Tabular Models
First of all I’d like to explain what a Role-playing dimension actually means. Then I’ll express the way you can…
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…
Resolving Format Cells Change after Refreshing Data Sources in Power Query
In this post I want to share my experience with refreshing data in Power Query and the way it affects…