Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.