Forum Discussion
Data refresh on demand from Power BI Server (report built using Import mode)
The answer by Anonymous is incorrect. The Power Automate (flow) and Power App solutions only work for the Power BI Service. There is not on-demand refresh built-in for the on-prem report server. If the user has permission to manage the scheduled refreshes they can go in and click the "Run Now" button on one of those, but you cannot link this into a report.
If you have the expertise to build a web application you could probably use the Web API calls to generate a scheduled refresh and trigger the "run now" action, but that would be a fair bit of work.
Hi speranzaa ,
You can refer to the solution given by Super user GilbertQ in the other thread.
"You can use Microsoft Flow to automatically refresh the data set on a schedule.
At the same time, you can create a Power App that connects to Microsoft Flow. you can then embed this Power App into your Power BI report where you can click a button to refresh the data."
Here is a blog post on how to get this done with Microsoft Flow: https://medium.com/@Konstantinos_Ioannou/refresh-powerbi-dataset-with-microsoft-flow-73836c727c33
For more information，you can also see the articles below：
Can we create custom 'Refresh dataset' button in Report page in PBI Service
Refreshing a Power BI Dataset by Button Click with Power Automate
HOW TO REFRESH DATASET USING BUTTON IN REPORT VIEW OF POWERBI?
Automatic page refresh in Power BI
Best Regards,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.