30
Hi guys,
Anyone have experience on how to integrate Power BI with Dynamics 365 on-premises environment. I have installed the Power BI report server and have enabled Power BI option on Dynamics settings. However, the option to create dashboard with Power BI doesn't show up. It works on online version, but doesn't work on on-premise environment.
I want to be able to have that Power BI dashboard option on on-premise environment. Is this possible/option available? Thank you
Hi ,
I would recommend to build your power bi on the desktop app using OData query as Data source, publish it to Power BI account and then use the HTML of the report and create a webresource in CRM, then add the webresource to the dashboard. That's how I accomplish my requirement.
Also to inform there is no synchronous auto refresh for this webresource in on-premise org. So you have to re-publish your report time & again.
Thanks
Prashant Verma
Hi Dipak,
Hope you Safe and well,
For embedding the Power Bi Dashboard you can follow the below-mentioned URL.
that will help you to configure with On-Prem.
docs.microsoft.com/.../dn708055(v=crm.8)
community.dynamics.com/.../integrate-dynamics-365-on-premises-with-power-bi-dashboard
Thanks,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (