cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrentMcA Frequent Visitor
Frequent Visitor

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 metadata document appears to be invalid"

 

I am using the OData endpoint URL that I copied from the Instance Web API section in D365 Settings eg:  https://crmxxxxx.api.crm.dynamics.com/api/data/v9.0/.

This is a clean install of Dynamics 365 so there is no customisation of the schema.

 

I can return the metadata in a browser and nothing obvious stands out.

 

I have successfully connected to a version 8 instance of Dynamics 365 so I know that I have the right steps.

 

Is there a known issue with Power BI desktop (latest version) and the July 2017 release of Dynamics 365?

 

 

Regards

Brent McA

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
BrentMcA Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

Excellent, that got it working.  Thanks.

View solution in original post

49 REPLIES 49
thaddeusmt New Member
New Member

Re: Dynamics 365 OData error with Power BI desktop

Even though you are connecting to a 9.0 instance, change your url to 8.2 and it will connect

https://yourorg.api.crm.dynamics.com/api/data/v8.2/

BrentMcA Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

Excellent, that got it working.  Thanks.

View solution in original post

Launchy Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

This doesn't seem to work for me

johnsaxton Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

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 Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

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

johnsaxton Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

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 Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

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 Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

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:

 

odata.png

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

johnsaxton Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

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 

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors