Hi,
i created a power bi chart in the desktop app, published it and displayed it on the role center in BC.
Sadly there is no automatic update currently. when creating new data its not shown in the chart, also not when clicking update in the power bi chart menu.
the data connection uses odata 4, a query. authentication via user/password.
updates only work via opening the chart in power bi desktop, update there the data, publish, then update power bi chart in BC. not great...
i checked the power bi dataset settings. there is some authentication failure, although it works in the desktop app.
i also created an oauth key, but have no clue how to use that in that scenario.
is there a working way how to get automatically/periodically updated power bi charts in bc role center?
is there a power bi pro/premium license needed?
You should first setup a scheduled refresh of the dataset in the Power BI Service.
With a PBI free license you can refresh once per day, with a Pro 8 times per day and with a Premium 48 times per day.
learn.microsoft.com/.../refresh-data
learn.microsoft.com/.../refresh-data
You need to understand that the BC PBI part shows the report, that is hosted on the PBI Service. It's the PBI Service that needs to refresh the data.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156