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 »

Show only the sales for the last 12 months

Recently I was helping someone on the Power BI community who wanted to only see the sales for the last 12 months in his chart, nothing more. Well this is pretty simple using DAX and I decided to use variables as well. The key here is to think about what you really want and see… Read More »

Bidirectional cross-filtering whitepaper

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 to flow for data using relationships between tables. In SQL Server 2014, filter context of a table is based on the values in a related table. With bidirectional cross-filtering the… Read More »

New role, new location

Recently I started at a new role in the Microsoft BI team as part of the customer engagement team, while it is still part of the larger BI product team at Microsoft it is no longer a active product development role. I loved working on amazing products like PowerPivot, SSAS Tabular, Power BI content packs and… Read More »