Using CUSTOMDATA and On-Premises SSAS with Power BI Embedded
Another Power BI embedded blog post while I have a playground up and running. Often when you want to use SSAS with Power BI embedded... Read more
Category: Analysis Services
Filter data based on a comma separated list using CALCULATE and PATHCONTAINS, even with external models!
Another interesting question I got this week kind of extends on the previous blog posts where I used disconnected slicers to filter data but this... Read more
Use calculated tables to show only used rows in dimensions
I got an interesting request this week, to improve the usability of the tabular model they wanted to filter the dimension table to only contain... Read more
Dynamic data comparisons using disconnected slicers, TreatAs and inactive relationships
Got a good question this week that had me scratching my head for a bit but then I remembered a new function that was added... Read more
Enterprise gateway sizing “recommendations”
I get asked this question a lot: “for my company xyz we want to set up an enterprise gateway, what machines or hardware should we... Read more
How it is build: the SSAS memory report
So recently I created a new SSAS memory report that you can use to analyze the memory usage of your SSAS servers, read more on... Read more
New SSAS memory usage report using Power BI
I have created several version of the SSAS memory usage report here and here. But with the new 1200 compatibility level these memory reports stopped... Read more
Analysis Services in Azure, when and why…
As you probably have seen is that Analysis Services is now available in Azure and you can read all about in this great blog post... Read more