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.

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? 

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