cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vbigham Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

@dpoggemann - You might need to add the entity name at the end of the URL to pull records into tables. In Dynamics CRM, the entity names should be pluralized.

 

For example (Advanced Editor code):

let
    Source = OData.Feed("https://my_org_name.api.crm.dynamics.com/api/data/v8.2/new_myrecords"),
in

    Source

 

You can create queries for each record type that you need. I would recommend creating "Shaped Tables" if you need to join multiple record types. That is to say, keep the queries basic, and then create new tables based on the queries that can merge, sort, filter, group, etc.

 

I hope this helps.

Highlighted
Rahul_Tiwary_90 Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

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/

 

datachamp Visitor
Visitor

Re: Dynamics 365 OData error with Power BI desktop

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

tpmeredith Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop


@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..

 

kdiggitydawg Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

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

pcowman Regular Visitor
Regular Visitor

Re: Dynamics 365 OData error with Power BI desktop

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.

kdiggitydawg Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

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?

pcowman Regular Visitor
Regular Visitor

Re: Dynamics 365 OData error with Power BI desktop

I get the remote name could not be resolved. Weird. I could connect before.

vbigham Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

Compare the URL you are using to what you find in CRM under Settings -> Customizations -> Developer Resources

 

Mine looks something like this:

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

kdiggitydawg Frequent Visitor
Frequent Visitor

Re: Dynamics 365 OData error with Power BI desktop

MS support engineer said if you're CRM instance is above 9.0.2.751, it will now include the fix and Power shouldn't have the issue anymore. 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors