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 working due to the DMV’s not working anymore for these databases. So I decided it would be time to create a new one for all models with compatibility 1200 and… 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 by Bret. I have spend a few days at the SQLClinic at SQLPass talking to many of you, one of the topics that often came up is on when it… 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 already supports this, even for Direct Query mode. So in this case you could have something like the following architecture: Dashboards and reports in Power BI that connect to an… 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 by a left outer join. This might not be what you would expect but this is a actually a solid design choice. The reason is that if your data would… Read More »

Power BI Desktop Dynamic security cheat sheet

I recently created this simple Power BI desktop file that allows you to try out dynamic security with the new security relationship feature as described in this blog post. The model contains the following tables: Sales – contains the metrics, the fact table Group – is the dimension table that groups a set of users.… Read More »

Dynamic security made easy with SSAS 2016 and Power BI

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 that allows you to move the user management from the user and role management of the SSAS metadata to be part the data itself. This makes it much easier to… Read More »

Use any map with Power BI

With the update of Power BI last week you can now add your own maps in any size or shape to Power BI so you can extend the set of out of the box shapes that come with Power BI. This is possible because the Shape map visual is build upon TopoJSON which is an… Read More »

Using multiple enterprise gateways to the same data source

Sometimes you want to be able to offload work for one of your Power BI Gateways as you might have many users who are building reports that need refreshing or are connecting live to the same data source, all of this is going over the same gateway machine, with the same CPU and bandwidth. It… Read More »