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".
Find out how to participate in the first Power BI 'Can You Solve These?' challenge.
Get your latest community news and announcements.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Each week, complete activities and be qualified in the drawing for cool Power BI Swag.