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.

tpmeredith's avatar
tpmeredith
Frequent Visitor
8 years ago

I checked this morning and mine are randomly working again using 8.2 API. Same server version/etc..

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

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