Forum Discussion
Dynamics 365 OData error with Power BI desktop
Hi, I am trying to connect Power BI desktop to Dynamics 365 Online.
After putting in the correct credentials, it starts to load the metadata then fails with this message:
"OData: The feed's metadata document appears to be invalid"
I am using the OData endpoint URL that I copied from the Instance Web API section in D365 Settings eg: https://crmxxxxx.api.crm.dynamics.com/api/data/v9.0/.
This is a clean install of Dynamics 365 so there is no customisation of the schema.
I can return the metadata in a browser and nothing obvious stands out.
I have successfully connected to a version 8 instance of Dynamics 365 so I know that I have the right steps.
Is there a known issue with Power BI desktop (latest version) and the July 2017 release of Dynamics 365?
Regards
Brent McA
Excellent, that got it working. Thanks.
49 Replies
Even though you are connecting to a 9.0 instance, change your url to 8.2 and it will connect
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..
Same issue here :smileysad:
Existing reports are still working but when i want to create a new report in Power BI Desktop with de Dynamics 365 API i get the same error message.
i'm using V8.2 and tried it on different organizations.
Stijnbakker were your existing reports using the org data svc linked above or the api? I made a dreaded MS support ticket so we'll see how that goes.. lovely ;\
My existing reports are using the api V8.2 at this moment. We will see how quickly the solve it ;)
Hello,
I'm using the Free version for Desktop (in italina Language).
The one from JUNE 2018 (the updated one just downloaded)
My Dynamics 365 Online is this: https://*****.api.crm4.dynamics.com/api/data/v8.2/ but it is not connecting (I'm logging as Dynamics 365 Admin - Not Office 365 Admin). Into the PowerBI Desktop Free Application, appears this error (in Italian because the PowerBI downloaded is in italian): Dettagli: "OData: Il documento di metadati del feed non è valido."
Can you help me?
Thank you.
Hello,
I'm using the Free version for Desktop (in italina Language).
The one from JUNE 2018 (the updated one just downloaded)
My Dynamics 365 Online is this: https://*****.api.crm4.dynamics.com/api/data/v8.2/ but it is not connecting (I'm logging as Dynamics 365 Admin - Not Office 365 Admin). Into the PowerBI Desktop Free Application, appears this error (in Italian because the PowerBI downloaded is in italian): Dettagli: "OData: Il documento di metadati del feed non è valido."
Can you help me?
Thank you.
Hi,
1. I'm new to Power BI
2. I'm connecting to a company that hasn't had CRM online connected to PowerBI before.
Several clients are getting the invalid metadata
For the company I am currently trying I have tried the above solutions and the closest I've come is it connecting but I have no tables showing to connect to. Is something wrong?
if i can see the metadata does that mean it's externalized properly? also say I'm connecting to appsource and it's using the office 365 account for the connection what authentication method should I be using?
very grateful for any help.
Try:
Get data: Other > Web
Basic: Add in URL table > https://yourD365instance.api.crm3.dynamics.com/api/data/v9.0/tablename
List, To Table, Ok, Column 1 Double Arrow
Sort from Natural Order to Name
Uncheck "User original column name as prefix"
Please confirm that works?
