- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Power BI and Odata (Dynamics 365 Business Central)
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Michael_Tucker on: New Card Visual inadvertently switching on values ...
- Gandalf12345 on: Copying Table with Filters is Ignoring Filters
- DNilsson on: March 2025 Update - Error fetching data for this v...
- BpTexan on: Snowflake connector isn't showing views after Marc...
- Tomasz_Skoczyla on: March 2025 update - Style preset error
- KrishnaKishoreK on: Conditional Formatting - Field Value not working a...
- jbongjbong on: Stretched App's Logo in Home Page "Recommended"
- pedrodr99 on: Button Slicer - Label - Color change not working
-
v-xiaoyan-msft on: Default Chart - Shape Map Is Not Working As Expect...
-
v-xiaoyan-msft on: Error (Exception from HRESULT: 0x80070002)
- New 7,874
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,084
- Declined 38
- Delivered 3,964
-
Reports
10,150 -
Data Modeling
4,094 -
Dashboards
4,082 -
Gateways
2,103 -
Report Server
2,099 -
APIS and Embedding
1,951 -
Custom Visuals
1,770 -
Content Packs
521 -
Mobile
353 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1