cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Can we create custom 'Refresh dataset' button in Report page in PBI Service

i have a report with dataset from web api datasource.  Currently I can schedule refresh for dataset for every 30 min. but I want to see live data or have a 'custom dataset refresh' button on the report page itself. so the users can click and refresh dataset. Right now i have to manually refresh dataset and then refresh the report. There are two steps involved. Is there any better way of getting live data better refresh options?

 

Also, in schedule refresh, to refresh every 30 min, i need to 'add time' for every 30 min intervals. It would have better if there is an option to select 'Every 30 min' instead of  'add time'

1 ACCEPTED SOLUTION
GilbertQ
Super User
Super User

Hi there

What you could do, is use Microsoft Flow to automatically refresh the dataset for you on a schedule.

Along with that you could then also create a Power App which links to the Microsoft Flow. You could then embed the Power App into your Power BI report, where you could click the 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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
GilbertQ
Super User
Super User

Hi there

What you could do, is use Microsoft Flow to automatically refresh the dataset for you on a schedule.

Along with that you could then also create a Power App which links to the Microsoft Flow. You could then embed the Power App into your Power BI report, where you could click the 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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

i was able to refresh dataset manually thru microsoft flow...but how can i schedule it for automatic refresh?

And also,i tried creating powerapp button and emebed that in my report, its working but the lok n feel of that button is not looking good on my report. How can I format it?  When i open report, the powerapp visual is loading the icon first and then it shows the button. Is there any way to disable the icon to not show?

Hi, How you did that? Can you please explain the steps!
Anonymous
Not applicable

Hi there,

I am not a Power Apps specialist but there is a way to remove the icon, you might have to Google on how to fix that issue.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors