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.

MerwinO's avatar
MerwinO
New Member
8 years ago

 I had the same problem.

 

However, since today I can connect again with all of these:

8.1

8.2

9.0

Old api (organization one)

 

Just to let you know

PBI_Curve's avatar
PBI_Curve
Icon for Helper I rankHelper 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.

  • stijnbakker's avatar
    stijnbakker
    Frequent Visitor
    8 years ago

    Thanks for the tip! It worked for me, form the blank query i can select the different tables in Dynamics 365. I hope the refresh still works when I publish my report to Azure. 

     

    We will see...

     

    Thanks!

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