Saturday 24 February 2018

Connecting Dynamics 365 v9.0 from Power BI

Though connecting to Dynamics 365 from Power BI Desktop is same old process , the As-Is Dynamics 365 9.0 Web API Url would not let you connect. A small change to the D365 API Url needs to be done when attempting a connection from Power BI. The 9.0 in the endpoint Url needs to be replaced with 8.1
Original API :-  https://organizationname.api.crm.dynamics.com/api/data/v9.0/ 
Url to be used :- https://organizationname.api.crm.dynamics.com/api/data/v8.1/ 
This would help you to prevent the error
Unable to connect

We encountered an error while trying to connect.

Details:"Odata: The feed's metadata document appears to be invalid."

The same is applicable when connecting using Power Query , Excel etc.

Note:  This approach has been tested on Power BI Desktop version -2.54.4970.961 64-bit (January 2018) & Dynamics CRM Version -1612 (9.0.1.510) (DB 9.0.1.510) online.
on
Labels: , , , , ,

5 comments:

  1. Unknown8 March 2018 at 06:59

    This comment has been removed by the author.

    ReplyDelete
  2. Unknown8 March 2018 at 07:11

    This doesn't work either.

    ReplyDelete
    Replies
    1. Srujan9 March 2018 at 09:33

      Could you let me know the exact version of Power BI Desktop(ex:-2.54.4970.961 64-bit (January 2018)) & Dynamics CRM ( ex:-Version 1612 (9.0.1.510) (DB 9.0.1.510) online ). This post has been validated with the versions mentioned in the brackets.

      Delete
  3. Santhu25 March 2020 at 06:24

    Thank you for this article it was very helpful, I have managed to connect, but will there be any impact using v8.1 instead of v9.1 ?

    ReplyDelete
  4. Admin13 October 2020 at 01:07

    Here is the site(bcomexamresult.in) where you get all Bcom Exam Results. This site helps to clear your all query.
    BA 3rd year Result
    DU BCOM 3rd Year Result 2020

    ReplyDelete

Subscribe to: Post Comments (Atom)