Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MappleLeaf
New Member

Power BI report using List data refreshing on each change

Hello Everyone,

 

I want to create a Power BI report which feeds data from a list stored in SharePoint Online and this report is displayed on a site page within SharePoint Online.

 

Whenever the list is modified, the Power BI report should be automatically refreshed. When I create the site page using a Power BI report, the site page is not automatically refreshed when the list data has changed.

 

How to achieve a live Power BI report (triggered everytime when there is a change in list  data stored on the SharePoint Online). 

 

I think the Power BI report is not refreshed automatically from the list stored in SharePoint Online and hence the site page is not refreshed as well.

 

Any pointers or suggestions are appreciated?

 

Thank you.

ML

 

 

 

3 REPLIES 3
lcdelgado
Helper I
Helper I

Still the same problem with Power BI service, that the data refresh every 3 hrs?

v-angzheng-msft
Community Support
Community Support

Hi, @MappleLeaf 

 

There is a limitation here, the data is refreshed every three hours.

 

vangzhengmsft_0-1629424740453.png

refer:

https://docs.microsoft.com/en-us/power-bi/create-reports/service-quick-create-sharepoint-list#known-...

 

I guess what you want to know is PowerBI's automatic page refresh. Change detection is the refresh type you want.

 

This refresh type allows you to refresh visuals on a page based on detecting changes in the data rather than a specific refresh interval. Specifically, this measure polls for changes to your DirectQuery source. Besides defining the measure, you also have to select how frequently Power BI Desktop will check for changes. When publishing to the service, this refresh type is only supported in workspaces that are part of a Premium capacity. LiveConnect sources such as Analysis Services and Power BI datasets are not supported

refer:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh#refresh-type...

 

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,
Community Support Team _ Zeon Zheng

This is just abysmal. "Power" BI can't even connect to a simple list within sharepoint and refresh the data reliably. Again, MS come close to a great solution and falls down at the basics. 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.