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

[amal_01]

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?

[uzuntasgokberk · Accepted solution]

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)

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[Anonymous · Accepted solution]

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.

[uzuntasgokberk · Accepted solution]

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)

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[amal_01]

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

[uzuntasgokberk]

Hello @amal_01 ,

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

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[amal_01]

@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 ?

[uzuntasgokberk]

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?

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |