Connect Dynamics 365 to Power BI

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/
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.

Continued Reading

Microsoft launches new email marketing and invoicing tools for small businesses

[vc_row][vc_column][grve_single_image image="17396"][vc_column_text]As written by Frederic Lardinois on techcrunch.com In the […]

LEARN MORE

Microsoft puts partners at the center of $4.5 trillion transformation opportunity

[vc_row][vc_column][vc_column_text] As written by Judson Althoff on blogs.microsoft.com As we […]

LEARN MORE

Contact us Today!

Chat with an expert about your business’s technology needs.