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
All about Power BI, Modelling, DAX and Microsoft BI
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
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
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
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
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
Dynamic security is one of those design patterns you hear mentioned every now and then by the seasoned SSAS pro’s. It is a design pattern... Read more
Bidirectional cross-filtering is a new feature for SQL Server 2016 Analysis Services and Power BI Desktop that allows modelers to determine how they want filters... Read more
With the just released CTP 3.3 for SQL Server 2016 Analysis Service we can now provide translations to your Tabular models. As you might have... Read more