Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Power BI and Odata (Dynamics 365 Business Central)

Microsoft Dynamics 365 Business Central 14.0.45012.0
Microsoft Power BI Desktop


The customer makes a report in Power BI Desktop then publish it to OneDrive and opens it in, and now wants to update the data.
The data source used is the Business Central OData service.


First we used the OData service with Windows authentication which works well with the Power BI Desktop app. However, after publishing the report and opening it in, you can't choose Windows authentication, but only basic or token.
We then made an instance with basic authentication to use instead. This works fine when using Internet Explorer.

However, it doesn't work if you use Edge or Chrome - and worse yet, it doesn't work in the Power BI Desktop app.

So how do we configure an OData service, that will work both in the Power BI Desktop app and on


Status: New
Community Support


I would suggest you use O365 Oauth2 as authentication.


by the way, for Dynamics 365 Business Central, I would suggest you refer to this and post your comment in here:




Regular Visitor

I should probably have mentioned we're a solutions provider of Dynamics 365 Business Central - and that we host those services in our own hosting center.

Regular Visitor

Finally found a solution that works.


We created an instance with NavUserPassword authentication, and a "webservices"-account with a web services key to use for this.


With this instance we could get both the Power BI Desktop app and working with basic logon (using the webservices account and web services key).