How to Refresh All Power BI Reports? Use Power Automate!

[@deepanshsaxena5677]

Loved it!! Thank you much for creating it.

[@cofelipe6]

Works very fine here, thank you bro!

[@juandavidardilatorres9126]

Hello sir, thanks for the video. I noted that the box that contained the last refresh time didn’t change. Do you know how to fix that?

[@smokeatlas]

Thank You for the video. Does it work when Power BI on my computer is closed? How can I make it work out of access to my computer but refresh it online?

[@heddyjazy6252]

very good, need how to send reporting automatically with power automate to a list of receivers. pro tips!

[@hogolytics]

We have some options, will create another videos for you. Follow the channel to get notified when it's get published.

[@dimindimin8306]

Hi. Thanks for the good video. Could u help me, how to refresh automatically datasets not simultaneously but each after other? I mean, when one dataset finished refreshing, next starts.

[@hogolytics]

Hi Dmytro, If you know how much it takes for each dataset to get refreshed, between each step you can add a delay step, similar to the time you need for refreshing each dataset. Then the next dataset refresh starts after N minutes when the previous one started. Cheers, Shahab

[@josecarlosbenitezmeyer645]

Hello, Amazing vídeo, really helpful, but by progamming the date and time Of the Dataset refresh, this will update a published report, who is already being showed on a TV?

[@zohra1047]

Great!

[@Al-vl3tp]

what if the Power Automate fails with a 5 min refresh and we have to cancel the dataset refresh in Power BI service. Does Power Automate has a flow or action to cancel out a data refresh? I would like to add this action if my data refresh fails and I can to cancel the data refresh on the Power BI side until the next scheduled API call from Power Automate.

[@blasegarrecht7330]

What if you don't want a button? How would you handle a monthly set day of month refresh since Power BI doesn't allow this? I want to just use refresh dataset from power automate, and then schedule it on 7th day of the month

[@utubebellamkonda]

What if I have more than 3 datasets? Can we get items from share point list and loop through?

[@alikeyhani9080]

Nice tip! Thanks a lot Shahab!

[@hogolytics]

Thanks for your comment Ali

[@thangnguyenhuu556]

Hi thanks for sharing, but in step select workplan, I can see my workplan, do you know why? Thanks

[@persiorak20D]

what if the data is from a sharepoint list? the button on the report is not refreshing after i update the sharepoint.

[@hhjkjjhhhjjjjj]

Thank You Sir!

[@harshyadav-qu8eb]

Hi , in my case date is not updating if I do refresh via web portal but in power BI desktop it does , any solution

[@hogolytics]

Have you checked if your refresh is not failing on service?

[@umarqayyum1098]

Thank You Sir

[@hogolytics]

Cheers

[@kuldar.]

Is it possible to refresh only selected tables in report and publish the result with Power Automate?

[@KomailButt]

The power automate flow has to be in run condition all the kind or it will automatically refresh on the schedule time selected?

[@hogolytics]

We have 3 types of flows: 1. Instant flows: running by pressing a button by user. 2. Scheduled flows: running by setting a schedule and will run on a specific time. 3. Automated flows: running by an event such as arrival of an email from a specific person, or a mention of your company in social media.

[@EhsanRavana]

karet dorosteh, like

[@hogolytics]

Thanks Ehsan jan, happy you liked it.

[@cpvardhan5968]

There is different way to automate more efficiently using Azure data factory and service principal

[@Harry-xi1wy]

how?

[@cpvardhan5968]

@@Harry-xi1wy search same in Google u will get it easily

[@manjunathrampure3567]

If i add the Run flow button in the same report which I want to refresh it's not refreshing and values are also not refreshing as well while in a published mode

[@hogolytics]

have you checked your refresh limit based on your license?

[@noprogramming]

how much limitation to refresh?

[@hogolytics]

Would you please explain more? What limitation you mean?

[@Lukzai]

​@@hogolytics With a Power BI Pro license, data refresh is limited to 8 times per day. Does using Power Automate to refresh the data still count toward this limit?

[@hogolytics]

@@Lukzai Thanks for your comment. Yes, that limitation will apply to whatever method you are using.

[@Wzxxx]

I think that manualy You can refresh without limit

[@SubinMathewz]

​@hogolytics Is there any workaround to refresh the dataset more than 8 times per day?? I have a power bi premium license User.. I have to share my report with pro users.Please suggest

[@UPHARANAND]

We have multiple ways to refresh a report. My question is , which refresh is fast

[@naiduvikas202]

Could people tell me is it this feature available for pro users or free users.. ? Im using free version if i share this flow my team members is it works..?

[@mohamedamine4425]

How to automate the publish report to app ???

[@hogolytics]

This is unfortunately not an option. You have to explicitly update the App to reflect your changes.

[@DZX5000]

this seems sketchy 😂

[@hogolytics]

Thanks