Forum Discussion

BrentMcA's avatar
BrentMcA
Regular Visitor
8 years ago
Solved

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 met...
  • BrentMcA's avatar
    BrentMcA
    8 years ago

    Excellent, that got it working.  Thanks.

PBI_Curve's avatar
PBI_Curve
Helper I
8 years ago

This should work for all those having trouble connecting PBI to their D365 instance.

Select "Get Data", then "Blank Query", Then input the following

 

= OData.Feed("paste your instance web api here") 

 

This should pull up everything from your instance.

tpmeredith's avatar
tpmeredith
Frequent Visitor
8 years ago
PBI_Curve wrote:

This should work for all those having trouble connecting PBI to their D365 instance.

Select "Get Data", then "Blank Query", Then input the following

 

= OData.Feed("paste your instance web api here") 

 

This should pull up everything from your instance.

This is exactly what we are all doing but the problem is in Dynamics 365/CRM 9.x the API is having issues with powerbi. It's fixed now but based on the thread wasn't the first time it's had issues sadly. Hopefully its fixed for good.

  • dpoggemann's avatar
    dpoggemann
    Frequent Visitor
    8 years ago

    Ok, so I am sorry I don't understand.

     

    I entered the information in a blank query as identified and it returned the information as rows in the query results but what do I do from there?  I am sorry, I was thinking I would have the ability to show a list of tables and then join them together, etc.  I don't see this.

     

    Sorry if stupid question. 

  • vbigham's avatar
    vbigham
    Frequent Visitor
    8 years ago

    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.