Showing results for 
Search instead for 
Did you mean: 
New Member

Automate Power BI dataset refresh when SharePoint List entry is done via PowerApps in Power BI?



I created a Power BI Report (my data source is SharePoint List) with integrated PowerApps to edit / copy & edit entries directly to the data source (i.e. the SharePoint List). It works very well, however, I have problem with automating the refresh of the Power BI dataset, as SharePoint Lists are not a DirectQuery / Live connection data source for Power BI.


And definitely I do not want end users to go to the Power BI workspace to refresh the related dataset every time they make an entry to the SharePoint List via the embedded PowerApps.


I explore(d) 3 solutions/options so far:


Option A: I tired to setup the  refresh the Power BI dataset via some formulas in the embedded PowerApps but it didn’t work (using PowerBIIntegration.Refresh() in the embedded PowerApp didn’t work and PowerApp didn’t take formula PowerBI.RefreshDataset(), suggested on YouTube).


Option B: I setup a scheduled refresh of the Power BI dataset but I have maximum 8 refreshes for 24 hours. I have Power BI Pro not Premium.


I consider trying Option C: Creating a PowerAutomate flow to refresh the Power BI dataset upon change in the SharePoint list.


Before doing that Option C ( I need to study how to do that)… does anyone has experience with Power BI dataset refresh with PowerAutomate and will I also have that limitation of 8 refreshes per 24 hours if I do the refresh via PowerAutomate?


Or Ideally…has someone “invented” a quick, almost live Power BI dataset refresh for NON DirectQuery / Live Connection dataset (e.g. SharePoint List)?


Thank you very much in advance for sharing your experience and helping me!



Frequent Visitor



I use the "When a file is created or modified in a folder" from SharePoint. I have an issue when a lot of files change at the same time, this create an alert that Power Automate "Throttle" my flow. That is because the update happens a couple of times at the same time. I followed this workaround - Power Automate – Limit Runs to Trigger One at a Time – Flow Alt Delete – Josh Cook [Microsoft MVP].



Hi Dolfvc,


thank you very much for your reply. Indeed last night the simple PowerAutomate flow (per this video) I created got throttled.


As this morning I got stuck when setting the Value filed in "Initialize variable" action per your example, I created a flow more or less per the article you shared:



And it got stuck:




It feels like Power Frustrate not like Power Automate  🤣


Any ideas what I can improve to make that working?


Its quite disappointing but so far it seems its much better to trigger manual refresh of the dataset 😟



Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

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!

Top Kudoed Authors