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
My CRM version is Microsoft Dynamics 365Version 1612 (220.127.116.11) (DB 18.104.22.168) on-premises. I am not able to see Power BI dashboard option after enable power BI from Sytemsettings Reporting Enable.
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".
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.
Join our monthly meetings and learning sessions.
We are excited to announce the Power BI Super Users!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.