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.

stijnbakker's avatar
stijnbakker
Frequent Visitor
8 years ago

My existing reports are using the api V8.2 at this moment. We will see how quickly the solve it ;)

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