web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Power BI Chart in BC Role Center, automatic update

(0) ShareShare
ReportReport
Posted on by 32,729

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?

I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    11,397 on at

    hi

    look this

    learn.microsoft.com/.../across-working-with-powerbi

    DAniele

  • Suggested answer
    Steven Renders Profile Picture
    5,672 Moderator on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans