Partner With Trusted Microsoft Specialists

Our team of certified technical experts have helped to digitally transform hundreds of businesses through Microsoft’s powerful tools and innovations, with specialized precision and multiple decades of experience.

Learn more about our Microsoft Dynamics solutions here. 

How to Connect Dynamics 365 to Power BI

By Ben Ward (2017)

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/

Power BI will then connect to the Dynamics 365 environment specified and return a list of available tables.