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.

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!