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

Odata Error: The Feed's metadata document appears to be invalid

I am having this issue using both Power BI and Power Query in Excel. I am not getting this error with a similar connection using a regular connection in excel 

9 REPLIES 9
Microsoft pqian
Microsoft

Re: Odata Error: The Feed's metadata document appears to be invalid

What's the OData endpoint?

rstov3r Frequent Visitor
Frequent Visitor

Re: Odata Error: The Feed's metadata document appears to be invalid

I am sorry. I am new to this. You mean the URL? 

https://odata.enersight.net/Version1311e201-9f9b-4afa-9e97-20ef72c15026

Microsoft pqian
Microsoft

Re: Odata Error: The Feed's metadata document appears to be invalid

I mean the URL you entered when you grab the feed.

 

That URL is guarded behind basic auth. So I'm not able to test it out. I wonder what happens when you do this in the browser:

 

https://odata.enersight.net/Version1311e201-9f9b-4afa-9e97-20ef72c15026/$metadata

 

If it's a valid end point, it needs to respond to this query with its CSDL. Similar to this:

http://services.odata.org/northwind/northwind.svc/$metadata

 

If it doesn't, then you may not have the right end point address. 

rstov3r Frequent Visitor
Frequent Visitor

Re: Odata Error: The Feed's metadata document appears to be invalid

Nothing happens when I add /$metadata to the end of that URL nothing happens. When I remove that tag and put in my basic auth, I get the following:

 

oData.JPG

 

 

 

Microsoft pqian
Microsoft

Re: Odata Error: The Feed's metadata document appears to be invalid

rstov3r Frequent Visitor
Frequent Visitor

Re: Odata Error: The Feed's metadata document appears to be invalid

Same as the above response

Microsoft pqian
Microsoft

Re: Odata Error: The Feed's metadata document appears to be invalid

@rstov3r, the response should be a JSON format string.

 

Looks like your target end point uses a custom OData implementation, and they did not follow the contract fully. Can you contact them and ask them about their $metadata implementation?

 

kdiggitydawg Frequent Visitor
Frequent Visitor

Re: Odata Error: The Feed's metadata document appears to be invalid

Hi rstov3r,

I just got it to work:

old = OData.Feed("https://d365_instance.api.crm3.dynamics.com/api/data/v8.2")
new = OData.Feed("https://d365_instance.api.crm3.dynamics.com/api/data/v9.0", null, [Implementation="2.0"])

this is what you need:

, null, [Implementation="2.0"]

8.2 or 9.0 seem to work after getting lots of metadata error messages! 🙂

kdiggitydawg Frequent Visitor
Frequent Visitor

Re: Odata Error: The Feed's metadata document appears to be invalid

Hi rstov3r,

I just got it to work:

old = OData.Feed("https://d365_instance.api.crm3.dynamics.com/api/data/v8.2")
new = OData.Feed("https://d365_instance.api.crm3.dynamics.com/api/data/v9.0", null, [Implementation="2.0"])

this is what you need:

, null, [Implementation="2.0"]

8.2 or 9.0 seem to work after getting lots of metadata error messages! 🙂

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)