Forum Discussion
Dynamics 365 OData error with Power BI desktop
Excellent, that got it working. Thanks.
Even I was facing the same issue. It's a known issue in Power BI and has been addresed in june 2018 release
I am able to connect to D365 (9.0) after this release upgrade
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2018-feature-summary/
I am using June 2018 release of Power BI Desktop but still get the same error message - Details: "OData: The feed's metadata document appears to be invalid."
This seems to happen with only certain version of Micrsoft Dynamics365
datachamp wrote:I am using June 2018 release of Power BI Desktop but still get the same error message - Details: "OData: The feed's metadata document appears to be invalid."
This seems to happen with only certain version of Micrsoft Dynamics365
Sorry to tell you but you'll have to contact MS support and they have to do something in backend to fix this. It's unrelated to version since my version stayed the same before/after their fix. Maybe related to what datacenter it is housed in? Who knows, but if it helps you can give them our ticket# 118062518454992. Microsoft said if we had the issue again it would help to reference the ticket# so they would know what fixed it..
On the Power BI Desktop side:
old = OData.Feed("https://d365_instance.api.crm.dynamics.com/api/data/v8.2")
new = OData.Feed("https://d365_instance.api.crm.dynamics.com/api/data/v8.2", null, [Implementation="2.0"])add this in
, null, [Implementation="2.0"]
seems to work, but cannot publish it to the BI workspace as I still get the same metadata error message
