cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sumi
Regular Visitor

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

I am trying to connect to dynamics 365 online from power BI and i am getting an error as 

 

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

 

The URL i am using to connect is https://<instance name>.api.crm.dynamics.com/api/data/v8.2/

 

I dont know if i am missing something , can someone help me with this ? TIA

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

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

Yeah, I ran into this and opened an Issue on it, there is a work-a-round:

 

https://community.powerbi.com/t5/Issues/Connecting-to-Dynamics-365-trows-error-about-invalid-OData/i...

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

10 REPLIES 10
Super User IV
Super User IV

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

Yeah, I ran into this and opened an Issue on it, there is a work-a-round:

 

https://community.powerbi.com/t5/Issues/Connecting-to-Dynamics-365-trows-error-about-invalid-OData/i...

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

View solution in original post

LizBethA Advocate I
Advocate I

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

The solution didn't work for me.  I am trying to connect to a On-Prem SharePoint site and get the same error.  I did create the blank query and copied the code and added my source, but continue to get the error message.

BuzzwordMaster
Regular Visitor

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

This solution does not work for me either. My situation is a little different, I have existing reports using data from Dynamics 365 that have not been able to refresh since Friday.

 

Same exact error message.

 

To rebuild these reports is extremely time consuming. I tried the solution above and it did not change anything. The only difference is my instance is crm3 (Canada) but aside from that I'm not sure what else to do.

NeroWasInnocent
New Member

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

We are experiencing the same issue in Canada. I can get it to work in Power BI Desktop (and subsequently publish the report) by altering the connect string to look like this:

 

Source = OData.Feed("https://ORGANIZATION.api.crm3.dynamics.com/api/data/v8.2", null, [Implementation="2.0"])

 

the key being to add the last two parameters, but I receive the same metadata error if I try to use the schedule refresh feature online when it asks for the credentials. At least the report can be published while I wait for Microsoft to work on the ticket. 

PhilippeAllard
New Member

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

I have the exact same problem, 

 

refresh works fine from powerbi desktop but it is impossible to schedule a refresh in powerbi Service .... My CRM is also crm3 ( Canada)...

 

Tried every solutions posted here... not working, ticket has been opened with microsoft for over 2 weeks.

dpoggemann
Frequent Visitor

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

Hi everyone,


So I have been testing this morning and have the following situation.  Trying to connect to online instance through Power BI Desktop and failing with the error.  

 

I did some more testing with other instances / environments I have access to and here is the results:

 

1.  Works fine with 9.0 instance (no MFA):   [version 1612 (9.0.2.449) (DB 9.0.2.449) online]

2.  Works fine with 8.2 instance (no MFA):   [Version 1612 (8.2.2.2060) (DB 8.2.2.2060) online]

3.  Does not work with 8.2 instance (MFA):  [Version 1612 (8.2.2.2060) (DB 8.2.2.2060) online]

 

Is this just an issue with MFA and how it is working with Power BI here?

 

Any similar situations for others?

 

Thanks,


Drew

pietvn
Regular Visitor

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

 

Also running into exact same issue for more than 1 week now. My CRM is also crm3 ( Canada)...

 

The PowerBI Desktop refresh works fine, schedule a refresh in web version no success.

Failed to update data source credentials: OData: The feed's metadata document appears to be invalid

 

Cheers,

Pieter

WCONGRAVE Advocate I
Advocate I

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

Hi,

 

Same Issue here - refresh works fine in Desktop but not when published to the web. Can we unmark this as solved, as it's not working!

WCONGRAVE Advocate I
Advocate I

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

FYI - just seen that this is listed on the powerBi Health Status monitor

 

"Users may be unable to connect to Dynamics CRM 9.0 using the OData connector in Power BI Desktop and Power BI Service. If this issue is impacting you, you'll see a connector error letting you know the feed's metadata document appears to be invalid. Engineers are working to deploy a partial mitigation to affected environments. Engineers are working on a complete mitigation. Next update @07/27/2018 17:00 PDT"

 

https://ideas.powerbi.com/knowledgebase/articles/668836-power-bi-service-health-status

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors