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
What's the OData endpoint?
I am sorry. I am new to this. You mean the URL?
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:
If it's a valid end point, it needs to respond to this query with its CSDL. Similar to this:
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:
Can you post the response of the following URL
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?
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! 🙂
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!