Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Power BI Chart in BC Role Center, automatic update

Posted on by 32,675

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?

  • Suggested answer
    Steven Renders Profile Picture
    Steven Renders 5,051 Super User 2024 Season 1 on at
    RE: Power BI Chart in BC Role Center, automatic update

    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.

  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 9,272 Super User 2024 Season 1 on at
    RE: Power BI Chart in BC Role Center, automatic update

    hi

    look this

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

    DAniele

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans