Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

PowerBI Report Online will not refresh automatically (data source: SharePoint list)

Hi there. I've seen this posted a few times now and cannot find an answer which resolves my issues. 


My Power Bi report online will not update unless I perform a manual refresh from the Desktop App and then re-Publish the report to the workspace.


My data source is a SharePoint list. In Desktop, I have imported the data source (rather than selected "visualise this in PowerBI" from the list). I have then created my report and published online to my workspace. When users update the SharePoint list, then the PowerBI report should update - but it never does. It is always showing old data. Whenever I perform a manual refresh in Dekstop and then re-publish, it updates the online report just fine (so there is no issue/errors with the data refresh).


I have done attempted three things which have not helped:

  • Set-up scheduled refresh (8x a day). It tells me that the refresh was successful, but the report visuals are not updated - doesn't work
  • Created a Power Automate flow which refreshes the data-set everytime the Sharepoint list is edited - doesn't work
  • Created a "Power Automate" button on the report which users can click to manually fresh the data-set. When clicked, it tells me that it is "triggered" and the data shows that it has been successful. However, the report visuals do not update - doesn't work

Even clicking the "refresh visuals" button on the report in PowerBi online does nothing. Why is it so hard to get the report visuals to update based on what the SharePoint list looks like? At this stage, I'd even take an hourly or even daily update!! As it stands, the only way I can update PowerBI online is t refresh the data-set in the desktop app manually and re-publish each time? I have to do this many times a day, just so the users can see the latest data in the report.


I'd be grateful for some help. I can provide screenshots if required.


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors