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
anom
Frequent Visitor

Need help related to Refresh Button with power automate

Hi, I have a report which has a refresh button with power automate and all the users has access to it. The button can be used 48 times per day with premium account, now I have the following questions -

 

1. Is it possible to show how many times the report was refreshed/button was clicked that day so the users can see how many refreshes are left for that day?

2. Is it possible to show which user used the refresh button last time?

3. After clicking the refresh button, the user needs to refresh the web page to see the update. Is there any way to see the updated report without refreshing the web page.

 

Also, are there any better solution for refresh button? Thank you.

1 ACCEPTED SOLUTION
v-yueyunzh-msft
Community Support
Community Support

HI ,  @anom 

Here are my understand for your question:
(1)Is it possible to show how many times the report was refreshed/button was clicked that day so the users can see how many refreshes are left for that day?

In Power BI, I haven't found a way to directly display the number of refreshes and the number of remaining times. After obtaining the refresh record, we can use the REST API to query:

Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Based on my query and research, there's seems to have some features published to limit the maximum times for a flow triggerring in a day, you may turn to the Power Automate community to get the more detailed help for this requirement. As I queried in the community, there are cases talking about this issue:

Solved: Power Automate Daily Limits - Power Platform Community (microsoft.com)

 

And for your this need , you can also post your idea to this website to make Power BI more better:
Home (microsoft.com)

 

(2)Is it possible to show which user used the refresh button last time?

At present, I have not found a direct way to implement this in Power BI. You can ask Power Automate if it can get the user information that triggered the flow last time for display?

 

View solution in original post

2 REPLIES 2
v-yueyunzh-msft
Community Support
Community Support

HI ,  @anom 

Here are my understand for your question:
(1)Is it possible to show how many times the report was refreshed/button was clicked that day so the users can see how many refreshes are left for that day?

In Power BI, I haven't found a way to directly display the number of refreshes and the number of remaining times. After obtaining the refresh record, we can use the REST API to query:

Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Based on my query and research, there's seems to have some features published to limit the maximum times for a flow triggerring in a day, you may turn to the Power Automate community to get the more detailed help for this requirement. As I queried in the community, there are cases talking about this issue:

Solved: Power Automate Daily Limits - Power Platform Community (microsoft.com)

 

And for your this need , you can also post your idea to this website to make Power BI more better:
Home (microsoft.com)

 

(2)Is it possible to show which user used the refresh button last time?

At present, I have not found a direct way to implement this in Power BI. You can ask Power Automate if it can get the user information that triggered the flow last time for display?

 

I found that you can get the name, email of the person who triggered the refresh button on power automate

anom_0-1690721850397.png

 

Thank you.

Helpful resources

Announcements
Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 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.

Top Solution Authors