Forum Discussion

BrentMcA's avatar
BrentMcA
Regular Visitor
8 years ago
Solved

Dynamics 365 OData error with Power BI desktop

Hi, I am trying to connect Power BI desktop to Dynamics 365 Online.    After putting in the correct credentials, it starts to load the metadata then fails with this message: "OData: The feed's met...
  • BrentMcA's avatar
    BrentMcA
    8 years ago

    Excellent, that got it working.  Thanks.

Launchy's avatar
Launchy
New Member
8 years ago

I engaged MS Support, and they said v9.0 is not currently supported.

johnsaxton's avatar
johnsaxton
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago
Tried 8.2. Issue remains. I'm doing a fresh install of PowerBI on a different machine to see if the problem is machine related
  • johnsaxton's avatar
    johnsaxton
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Same issue different machine accessing same URL. Still receiving the same error regardless of version in the URL.

     

    BTW... all of the following URLs work poerfectly in IE, Edge, Firefox, Opera... but not in PowerBI

     

    https://<my tenant>.crm.dynamics.com/api/data/v8.2/ <-- returns OData JSON of all Entities

    https://<my tenant>.crm.dynamics.com/api/data/v9.0/ <-- returns OData JSON of all Entities

    https://<my tenant>.crm.dynamics.com/api/data/v8.2/accounts <-- returns all Account data

    https://<my tenant>.crm.dynamics.com/api/data/v9.0/accounts <-- returns all Account data

    https://<my tenant>.api.crm.dynamics.com/api/data/v8.2/accounts <-- returns all Account data

    https://<my tenant>.api.crm.dynamics.com/api/data/v9.0/accounts <-- returns all Account data

     

    Is there a dependency I am missing. Am I missing something in my URL? 

     

    Is there a way for me to see the actual response message? 

    • smoov01's avatar
      smoov01
      Frequent Visitor
      8 years ago

      I am also experiancing this issue even though I am pointing at the v8.2 api in my URL.  I have tried it with several organization tenants for different customers and they all fail to load any oData information from Dynamics.   I had other coluges try to connect to our service with the same results:

       

      I need to open a ticket, but not sure if it is a Dynamics 365 issue, or PowerBI.

      • johnsaxton's avatar
        johnsaxton
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        Smoov01

        If you paste the OData URL into a browser are you getting a valid JSON document back? If you do, then I think the problem is PowerBI, not Dynamics. 

         

        Append one of your entity types to the URL,  https://<your tenant>.crm.dynamics.com/api/data/accounts  (For example) this will return all of you account data. IF you get that in a browser, the issue is PowerBI

         

        John