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
Category: Microsoft BI
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... Read more
Use Task Scheduler and PowerShell to process your SSAS database
Most of the times you will use SSIS or a SQL Agent job to process a SSAS model, but sometimes you don’t have either one... 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... 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... Read more
Determine slicer (or visual) influence on other visuals in Power BI
Just a quick one today as I do get this questions every now and then: How can I change which slicers interacts with a visual?... 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... 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,... Read more