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

This doesn't seem to work for me

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

Not working for me either. 

 

I tried changing the API version in the URL I supply to PowerBI doesn't make any difference. Still get the same excuse

 

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

 

 

Yet the exact same URLs that fail in PowerBI work just fine in the browser. I am able to retrieve the OData JSON.

 

Thoughts?

 

 

  • 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?