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
Category: Power BI
Use the Power BI quick calcs with your own date table
Just a quick one today on how you can use the Power BI quick calcs with you own date table. I have a very simple... Read more
Use Always Encrypted data with SSAS and Power BI
I got an interesting question today about using Always Encrypted columns with SSAS and Power BI and it turns out it this just works. Let’s... Read more
Bulk assign Power BI licenses using Azure AD
Another interesting question that I got earlier this week is how to assign bulk Power BI licenses to users based on their group membership. Fortunately... Read more
Power BI security enhancements with Azure AD conditional access
Just a quick blog post today to highlight one of the Power BI integration points that we get “for free” being part of the overall... Read more
Enterprise gateway sizing “recommendations”
I get asked this question a lot: “for my company xyz we want to set up an enterprise gateway, what machines or hardware should we... Read more
Automatically apply filters to your report per user
This was an interesting case I did a while ago where they wanted to have a report that automatically provided a set of filters to... Read more
Disable Power BI Workspace or group creation for certain users or groups
One of the questions that I get asked sometimes is how to prevent users from creating groups / workspaces in Power BI. I recently found... Read more