topic Re: Dynamics 365 OData error with Power BI desktop in Power Query

Dynamics 365 OData error with Power BI desktop

BrentMcA — Thu, 25 Jan 2018 01:55:32 GMT

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

Re: Dynamics 365 OData error with Power BI desktop

Anonymous — Thu, 25 Jan 2018 17:54:24 GMT

Even though you are connecting to a 9.0 instance, change your url to 8.2 and it will connect

https://yourorg.api.crm.dynamics.com/api/data/v8.2/

Re: Dynamics 365 OData error with Power BI desktop

BrentMcA — Tue, 30 Jan 2018 22:18:00 GMT

Excellent, that got it working. Thanks.

Re: Dynamics 365 OData error with Power BI desktop

Launchy — Wed, 14 Feb 2018 09:42:18 GMT

This doesn't seem to work for me

Re: Dynamics 365 OData error with Power BI desktop

johnsaxton — Wed, 14 Feb 2018 19:59:54 GMT

Not working for me either.

I tried changing the API version in the URL I supply to PowerBI doesn't make any difference. Still get the same excuse

"OData: The feed's metadata document appears to be invalid."

Yet the exact same URLs that fail in PowerBI work just fine in the browser. I am able to retrieve the OData JSON.

Thoughts?

Re: Dynamics 365 OData error with Power BI desktop

Launchy — Thu, 15 Feb 2018 00:50:09 GMT

I engaged MS Support, and they said v9.0 is not currently supported.

Re: Dynamics 365 OData error with Power BI desktop

johnsaxton — Thu, 15 Feb 2018 01:13:30 GMT

Tried 8.2. Issue remains. I'm doing a fresh install of PowerBI on a different machine to see if the problem is machine related

Re: Dynamics 365 OData error with Power BI desktop

johnsaxton — Thu, 15 Feb 2018 13:35:42 GMT

Same issue different machine accessing same URL. Still receiving the same error regardless of version in the URL.

BTW... all of the following URLs work poerfectly in IE, Edge, Firefox, Opera... but not in PowerBI

https://<my tenant>.crm.dynamics.com/api/data/v8.2/ <-- returns OData JSON of all Entities

https://<my tenant>.crm.dynamics.com/api/data/v9.0/ <-- returns OData JSON of all Entities

https://<my tenant>.crm.dynamics.com/api/data/v8.2/accounts <-- returns all Account data

https://<my tenant>.crm.dynamics.com/api/data/v9.0/accounts <-- returns all Account data

https://<my tenant>.api.crm.dynamics.com/api/data/v8.2/accounts <-- returns all Account data

https://<my tenant>.api.crm.dynamics.com/api/data/v9.0/accounts <-- returns all Account data

Is there a dependency I am missing. Am I missing something in my URL?

Is there a way for me to see the actual response message?

Re: Dynamics 365 OData error with Power BI desktop

smoov01 — Thu, 15 Feb 2018 15:28:45 GMT

I am also experiancing this issue even though I am pointing at the v8.2 api in my URL. I have tried it with several organization tenants for different customers and they all fail to load any oData information from Dynamics. I had other coluges try to connect to our service with the same results:

I need to open a ticket, but not sure if it is a Dynamics 365 issue, or PowerBI.

Re: Dynamics 365 OData error with Power BI desktop

johnsaxton — Thu, 15 Feb 2018 18:25:17 GMT

Smoov01

If you paste the OData URL into a browser are you getting a valid JSON document back? If you do, then I think the problem is PowerBI, not Dynamics.

Append one of your entity types to the URL, https://<your tenant>.crm.dynamics.com/api/data/accounts (For example) this will return all of you account data. IF you get that in a browser, the issue is PowerBI

John

Re: Dynamics 365 OData error with Power BI desktop

smoov01 — Fri, 16 Feb 2018 22:03:06 GMT

Yeah those all work fine with a web browser. I have a ticket open with Microsoft, and they are trying to figure out what is causing it. Will post back when I know more.

Re: Dynamics 365 OData error with Power BI desktop

BrentMcA — Mon, 19 Feb 2018 01:16:28 GMT

And...it is no longer working for me either. Nothing I have changed. :smileysad:

Re: Dynamics 365 OData error with Power BI desktop

smoov01 — Mon, 19 Feb 2018 03:04:24 GMT

I have four other PowerBI D365 users that have verified this has stopped working without their having changed anything. Still no word back from Microsoft support.

Re: Dynamics 365 OData error with Power BI desktop

BrentMcA — Tue, 13 Mar 2018 22:04:49 GMT

And...it is working for me again. Nothing I have changed. :smileyhappy:

Still needs to have the ...\v8.2

Re: Dynamics 365 OData error with Power BI desktop

Brackee — Wed, 20 Jun 2018 08:10:25 GMT

I am having trouble using v8.2 as i dont have v9 yet.

I have the lates june update of Power BI.

The error occurs if i try to add a new data source using the Dynamics 365 (Online).
However, if i use the recent data sources provided before the error occured, it work as before.

So for me i can still work. But, my coworkers are not so fortunate, they did not connect up before the problem occured and experience the error as provided in the post.

I hope this will be solved soon.

Re: Dynamics 365 OData error with Power BI desktop

SergioRota — Thu, 21 Jun 2018 14:24:17 GMT

Same situation for me :smileyindifferent:

Re: Dynamics 365 OData error with Power BI desktop

vbigham — Thu, 21 Jun 2018 18:21:49 GMT

Same situation for me as well. I worked around the issue by hand-coding OData.Feed() queries to get the data, this worked well to design and create the reports. But now, the published data set cannot be refreshed and results in an error. I've opened a support ticket to try to get a resolution.

Re: Dynamics 365 OData error with Power BI desktop

tpmeredith — Mon, 25 Jun 2018 14:44:12 GMT

Same for us, we updated to 9.0 and all powerbi reports are broken now :(

8.2, 8.1, 9.0 all results in metadata feed errors..

Re: Dynamics 365 OData error with Power BI desktop

tpmeredith — Mon, 25 Jun 2018 15:53:41 GMT

Also so everyone knows I have older powerbi reports I built initially using the organization data service (example https://******.crm.dynamics.com/XRMServices/2011/OrganizationData.svc ) and it is still working, only the ones trying to use the API web service are broken.

I tried replacing the API with that url and it didnt work sadly, not sure how easy/hard it would be to change existing complex queries/reports to use that instead.

Re: Dynamics 365 OData error with Power BI desktop

stijnbakker — Tue, 26 Jun 2018 10:39:35 GMT

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.