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:
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.
August 18, 2017
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
August 21, 2017
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