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.

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/

 

Highlighted
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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 512 members 4,991 guests
Please welcome our newest community members: