Products: Microsoft Dynamics 365 Business Central 14.0.45012.0 Microsoft Power BI Desktop app.powerbi.com OneDrive
Description: The customer makes a report in Power BI Desktop then publish it to OneDrive and opens it in app.powerbi.com, and now wants to update the data. The data source used is the Business Central OData service.
Problem: 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 app.powerbi.com, 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 app.powerbi.com?