Create a Power BI Refresh Button Inside Your Reports

[@HowToExcelBlog]

Check out my full courses and ebooks here 👉 www.howtoexcel.org/courses/

[@braveheartingux]

Top video, no bullshit , just nice and quick workaround

[@EricaShapland]

This is exactly what I was looking for. Thank you!

[@HowToExcelBlog]

Read the other comments for a better way using non premium license.

[@brockyoutube]

Great tutorial and very easy to follow. Thanks!

[@HowToExcelBlog]

There is now a power automate visual in power bi, which I assume can do this but better!

[@wayneedmondson1065]

Thanks John. Thumbs up!!

[@shubhabratadey]

Great video. Thanks

[@hakiki1518]

brilliant !!! thank you bro

[@HowToExcelBlog]

No problem 👍

[@emilbochnik]

Hi do you know how to create step in automate to send out emial notification once the dataset is refreshed? thank you

[@steffenmlgaardlarsen5463]

This is working like a charm - But Have you found a way, where opening a new tab can be avoided when pressing the refresh button?

[@HowToExcelBlog]

I haven't really investigate tbh. But I was thinking you might be able to use the power apps visual, build a simple app with only a button in it, have that button trigger a flow via the power apps trigger, Flow refreshes the dataset. This could also mean you can set who is able to use the button. Let me know if you try it out.

[@steffenmlgaardlarsen5463]

@@HowToExcelBlog You are right. The flow was easy to implement into a PowerApp embedded onto the Powerbi report. Around 20-minute research and implementation time :-)

[@HowToExcelBlog]

Glad it worked!

[@HowToExcelBlog]

Are you able to resize it so it looks just like a button and not an app with a button on it?

[@steffenmlgaardlarsen5463]

@@HowToExcelBlog Yep - I made a giant button that took up the full canvas on a horizontal layout. Then I put the button onto the powerBI report, and resized it as I saw fit. :-)

[@annmariedominion]

very helpful! Thank u

[@kobesaf0811]

Hi John Great presentation much appreciated. I would like to know if you can suggest the best formula which would enable you identify counts of full and partial payment for a set of figures in a spreadsheet . Thanks.

[@HowToExcelBlog]

That totally depends on what your data looks like.

[@kobesaf0811]

@@HowToExcelBlog Can I send it through and have a look for me?

[@Shootz2K]

Thanks for this, very useful. Question I have is there a way to add a cool down to the request? I have a report that takes about 15 minutes to refresh and several people have access. This means I can end up with a few failed flow runs as the button is pressed before the last refresh finishes. What would be great is that if someone clicks the button within a timeframe (15 minutes in this case) the page doesn't state success but instead tells them a refresh has already been triggered at X time and they can try again 15 minutes from the last refresh.

[@habibullahshaik6986]

Thank you. Is there a way to suppress the pop up window which open when refresh is clicked?

[@HowToExcelBlog]

Try an embedded power app that has a button which triggers a flow instead. Also not a premium feature.

[@CharlesRo-o6k]

So this appears to be refreshing in a workspace. I'm looking to refresh in teams. Is tehre a video which instructs this?

[@mostafa_farid]

Is this also limited to 8 times only?

[@HowToExcelBlog]

Yes, I believe so. But that might have changed since publishing this video.

[@robbie337]

Hey - Great video. I'm a Power BI Pro User, so I am permitted 8 scheduled refreshes per day. Does a refresh via this method count toward my 8 permitted refreshes, or does it count as a manual refresh. Thanks?

[@HowToExcelBlog]

Good question. I assumed it was part of the 8, because otherwise you can schedule refreshes more than 8 times a day via power automate and a schedule trigger.

[@Tesza09]

Sadly it does, just reached my limit after 2 hours of work.

[@ysze89]

I don't have the "refresh page" button in BI, and is it a must to have a direct query ? i don't know how to set up? any way I can do the refresh?

[@lorinamuca6461]

Hello! This video was very usefull and exactly what i needed. But some how i get this error when i make the refresh of the report in the service: "Data source error. It looks like scheduled refresh failed because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources." Instead in power automate the run its succeeded. Thank you in advance.

[@kameswarielectricals2149]

Not able to trigger the flow by the report viewers with whom we shared the report. How can we do that??

[@akhilholla]

For refreshing the from power BI do we need power Automate to have some subscriptions? I am getting the below error. "{"error":{"code":"WorkflowTriggerIsNotEnabled","message":"Could not execute workflow '544eb5e8-25ce-4a6f-901f-10dd8f72084f' trigger 'manual' with state 'Suspended': trigger is not enabled."}}"

[@HowToExcelBlog]

Yes, http trigger is premium.

[@HowToExcelBlog]

I realised, you can use embedded power app where app has a button that trigger a flow. This setup would be standard license.

[@AlbertodaSilva1972]

How do you notify user once the data refresh is done?

[@HowToExcelBlog]

Unfortunately, you can't do that yet.

[@eduardomontiel504]

Is Flow free? First time hearing and using Flow. I got this message "Your flow was saved, but could not be enabled because of billing restrictions. Learn more ."

[@HowToExcelBlog]

Not all features in Flow are free. The http action in this video needs a premium license.