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
Category: Microsoft BI
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
Embedding Power BI Reports with Power BI Report Server
A common question I get is what will we will be able to do around embedding Power BI reports with Power BI report server. To... 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
Use SQL Server RLS with SSAS and Power BI
One of the questions I get regularly now that SQL Server supports RLS is how can to leverage this with SSAS. What many don’t know is that SSAS... Read more
Improve performance with DirectQuery by using Inner Joins
If you have ever looked at the queries generated by DirectQuery you will see that a query that retrieves data from multiple tables gets joined... Read more