Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
BrentMcA
Regular Visitor

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

 

 

1 ACCEPTED SOLUTION

Excellent, that got it working.  Thanks.

View solution in original post

49 REPLIES 49

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors