cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular 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
Frequent Visitor

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! 🙂

Frequent Visitor

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! 🙂

Microsoft
Microsoft

What's the OData endpoint?

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

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

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. 

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

 

 

 

Same as the above response

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

 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors