Using CUSTOMDATA and 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 you have a “authentication issue”. Power BI and SSAS both leverage AD so that means that any user you pass from Power BI to SSAS needs to be known in AD. Now that is great in enterprise scenario’s where this usually is the case (and even required) but for ISV’s... 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 in both cases is how can I make sure I filter my report before any queries are being send to the underlying data source. When using Power BI embedded you can use Javascript to pass in a filter instead of using the Power BI UI. To test how this worked... 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 the rows that have data in the fact table. That way the slicers and other filters will never have data where you don’t have any sales or any facts. Often this is taken care before loading the data by creating view or writing queries but in this case this would... Read more