Menu

We are apologize for the inconvenience but you need to download
more modern browser in order to be able to browse our page

Download Safari
Download Safari
Download Chrome
Download Chrome
Download Firefox
Download Firefox
Download IE 10+
Download IE 10+

How to Connect Dynamics 365 to Power BI

How to Connect Dynamics 365 to Power BI

By Ben Ward
With the release of the latest Dynamics 365 API, analysts can now connect Dynamics 365 to Power BI and download data up-to five times faster compared to the previous version of the API. This is great news to any analyst who is looking to mine, analyze and visualize large data sets hosted in Dynamics 365. This is especially helpful to those who are trying to analyze email sends for an organization as these data sets can exponentially grow.
To connect Dynamics 365 to Power BI, log in to Dynamics 365 and go to Settings > Customizations > Developer Resources and copy the Service Root URL.
It will look like this:
https://yourdomainname.api.crm.dynamics.com/api/data/v8.2/
Next, open Power BI and click on Get Data > Online Services and select Dynamics 365 (online) then click Connect. Paste the URL copied above into the Web API URL field and click on OK.
Power BI will then connect to the Dynamics 365 environment specified and return a list of available tables.