Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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! 🙂
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! 🙂
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:
Can you post the response of the following URL
https://odata.enersight.net/Version1311e201-9f9b-4afa-9e97-20ef72c15026/?$format=json
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |