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
All about Power BI, Modelling, DAX and Microsoft BI
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
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
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 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
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
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
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
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