web
You’re offline. This is a read only version of the page.
close
Skip to main content
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,376 on at
    RE: Power BI Chart in BC Role Center, automatic update

    hi

    look this

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

    DAniele

  • Suggested answer
    Steven Renders Profile Picture
    5,668 Moderator 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.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,330

#2
Sumit Singh Profile Picture

Sumit Singh 2,738

#3
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 2,546

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans