I have a Microsoft CRM 2016 on-premise instance with a lot of data and possibly thousands of users. I created a SSAS warehouse to gather and process data from CRM instance. Now I want to show Power BI reports built on this data in CRM dashboards.
If I use data import to BI, then there is an available option "Publish to the web", so I can put a report in iframe in CRM dashboard, which is very convenient.
But I really want to use live connection, so I will not need data refresh and will be able to work with big amounts of data. And "publish to the web" option is unavailable for live connections.
Is there a workaround to work with BI reports live connection and embedding reports in iframe? Power BI Embedded also doesn't apply, cause I don't have my own app, but Microsoft CRM on-premise instance.
Any help is much appreciated
Hi, You can use Tiles from Power BI in MS Dynamics CRM dashboards.
You need to enable this as administrator in CRM:
Now you should have an icon when creating your dashboards that says "Add a Power BI tile to this dashboard".