How to turn on SSAS profiler traces in Power BI desktop
Just a quick post today. Power BI desktop has a feature to turn on the SSAS profile traces that allows you to see all the... Read more
Category: Power BI
Change your Power BI report to point to an external SSAS model
A common questions I get is to change the connection string to from my report to SSAS after I move my Power BI desktop file... Read more
Currency conversion in DAX for Power BI and SSAS
Another interesting question that came up recently is how to do currency conversion in Power BI. My colleague Jeffrey Wang had a very neat solution... Read more
Using CUSTOMDATA and On-Premises SSAS with Power BI Embedded
Another Power BI embedded blog post while I have a playground up and running. Often when you want to use SSAS with Power BI embedded... Read more
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
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
UPDATE: you can now use measures as filter of a slicer so this post is outdated, please read here for what the recommendation is today:... 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