Connecting to Dynamics 365 trows error about invalid OData metadata

[Greg_Deckler]

Trying to connect to:

https://<tenant>.api.crm.dynamics.com/api/data/v8.2/

Throws error that metadata is invalid. This is using OData connector or Dynamics 365 (online) connector.

[Anonymous]

@Greg_Deckler,

I have reported this issue internally: CRI 72081044. Please use the workaround below.

Create a blank query in Power BI Desktop, copy the following code into Advanced Editor of this blank query.

let
    Source = OData.Feed("https://<tenant>.api.crm.dynamics.com/api/data/v8.2/")
in
    Source

Regards,
Lydia

[Greg_Deckler]

Thanks, I will give that a try.

[BuzzwordMaster]

@Anonymous,

Is there a workaround for existing reports? I have a number of PBI reports pulling from Dynamics 365 (for the last 8+ months) and they have not been able to refresh since this past Friday.

I tried adding your solution to an existing query in desktop (thinking I could then republish if it worked) and still recieved the same error as the original post.

It would take a ton of time to rebuild these reports.

Thanks in advance.

[CezarSteinz]

I created a new report using the lastest power bi desktop version and see 2 new parameters on Advanced Editor, like this:
Lastest source:

Source = OData.Feed("https://myclient.crm2.dynamics.com/api/data/v8.1/"),
New source:
Source = OData.Feed("https://myclient.crm2.dynamics.com/api/data/v8.1/", null, [Implementation="2.0"]),

Then, I added ", null, [Implementation="2.0"]", on my old reports, and it works fine on Power BI Desktop. But this error persists after deploy on Power BI Web... It's a workaround that only fix this issue on Power BI Desktop but it continues on Web.

[BuzzwordMaster]

@CezarSteinz

This is exactly what I ended up doing, except now (like you) my issues lies with the web service not being able to refresh due to invalid OData credentials. Desktop accepts the same credentials just fine.

[dpoggemann]

Hi everyone,

So I have been testing this morning and have the following situation.  Trying to connect to online instance through Power BI Desktop and failing with the error.  

I did some more testing with other instances / environments I have access to and here is the results:

1.  Works fine with 9.0 instance (no MFA):   [version 1612 (9.0.2.449) (DB 9.0.2.449) online]

2.  Works fine with 8.2 instance (no MFA):   [Version 1612 (8.2.2.2060) (DB 8.2.2.2060) online]

3.  Does not work with 8.2 instance (MFA):  [Version 1612 (8.2.2.2060) (DB 8.2.2.2060) online]

Is this just an issue with MFA and how it is working with Power BI here?

Any similar situations for others?

Thanks,

Drew

[BenTes]

I'm having the same issue and I'm 99.9% sure we have MFA...

[sbandaru]

Hi all,

I am facing similar issue. It works perfectly fine with PowerBI Desktop after added two options  null, [Implementation="2.0"]). However, I am getting Metadata issue in PowerBI Service as "Failed to update data source credentials: OData: The feed's metadata document appears to be invalid." while trying to update powerbi dataset credentials.  

Is this something that Microsoft needs to fix at CRM Connector?

[HowlingWolf]

Any updates on the issue?