cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rstov3r
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
Anonymous
Not applicable

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

Anonymous
Not applicable

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

pqian
Microsoft
Microsoft

What's the OData endpoint?

rstov3r
Regular Visitor

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. 

rstov3r
Regular Visitor

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

 

 

 

rstov3r
Regular Visitor

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.