topic Re: Can I add a button that refreshes the data in power bi server in Report Server

Can I add a button that refreshes the data in power bi server

amal_01 — Mon, 11 Nov 2024 07:41:02 GMT

I have created client's project then published it.
Now The client want to add a button that refreshes the data when he click on it . How can I do this?

Note : I know that I can setup a scheduled refresh but the client want a button
Any Help?

Re: Can I add a button that refreshes the data in power bi server

uzuntasgokberk — Mon, 14 Jul 2025 14:02:36 GMT

Hello amal_01 ,

Yes you can with Power Autome , it is possible. Use the visualizaion "Power Automate for Power BI" in Power BI Desktop. Edit the Power Automate for Power BI with instant click. You need configure which semantic model needs to be refreshed etc.

Example video: Using Power Automate to Refresh Data In Power BI (youtube.com)

Re: Can I add a button that refreshes the data in power bi server

amal_01 — Mon, 11 Nov 2024 10:29:57 GMT

uzuntasgokberk
I did these steps but when the client click on the button it does not work , it is just work with me

Re: Can I add a button that refreshes the data in power bi server

uzuntasgokberk — Mon, 14 Jul 2025 14:01:27 GMT

Hello amal_01 ,

You need to give a permission to the client. You can give an access with Share or Run Only Users.

Re: Can I add a button that refreshes the data in power bi server

amal_01 — Mon, 11 Nov 2024 12:55:23 GMT

uzuntasgokberk
I already gave him permission
added him in Run only users , also in Co-owners
when he click on the button it show message unsuccessful
Any Idea ?

Re: Can I add a button that refreshes the data in power bi server

uzuntasgokberk — Mon, 14 Jul 2025 14:01:12 GMT

Hello amal_01 ,

You're probably missing something. İt should be worked because I've been using this method.

What is your license mode in the workspace?

Re: Can I add a button that refreshes the data in power bi server

Anonymous — Tue, 12 Nov 2024 02:59:30 GMT

Your solution is so great uzuntasgokberk

Hi, amal_01

Here's the whole process of configuring a refresh through automate:

Make sure that your current report already exists in your workspace:

You need to configure the gateway connection for this semantic model:

Open the report in Power BI desktop and add a Power Automate button:

Publish the report with the Power Automate button to the workspace and replace the original report.

Then, share the report with your users:

Here's what your current users are experiencing:

To solve the current problem, we first need to give the user permission to the semantic model:

Then go to Power Automate web and give this user permission:

Then your user successfully triggers a refresh of the dataset:

While you're fulfilling the demand for your users, Power BI limits the semantic model on a shared capacity to 8 scheduled semantic model refreshes per day due to the Power BI refresh limit.

Data refresh in Power BI - Power BI | Microsoft Learn

Refresh fails after your user clicks the button more than 8 times. Of course, you have the option to upgrade to Premium capacity, which limits the number to 48.

Best Regards

Jianpeng Li

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