Embed your Power BI report with predefined filters
I have recently gotten this questions a few times so time to dust off my coding skills and get to work … the key question... Read more
Category: Power BI
Filter data based on a comma separated list using CALCULATE and PATHCONTAINS, even with external models!
Another interesting question I got this week kind of extends on the previous blog posts where I used disconnected slicers to filter data but this... Read more
Use calculated tables to show only used rows in dimensions
I got an interesting request this week, to improve the usability of the tabular model they wanted to filter the dimension table to only contain... Read more
Build your own usage report with Power BI
Yesterday I found out we have a great feature in Power BI that everyone should know about but I stumbled upon by accident. it turns... Read more
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
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