Refresh All Datasets from Power BI Desktop with 1 Click

[@BIElite]

A couple things I forgot to mention: 1) Refreshing a dataset in this manner uses up one of your scheduled refreshes. If you are on Power BI Pro, this uses 1 of the 8 allotted scheduled refreshes per dataset per day. For Premium, you have 48 scheduled refreshes per dataset per day. 2) This video is focusing on Power BI Desktop, but if you want to publish this up to Power BI Service and share with others, make sure to add the desired users under the "Run only users" when setting up the Power Automate flow.

[@luisangelgaitan7436]

HI, Great video, could you tell me how I can download this pbi file?

[@RajendraPatel.]

Woouuu it's dynamic 😊😊 lots of BI 💕 lover in India

[@adamcolquhoun8392]

Very nice solution, I wonder is there a way to then check the last refreshed date and time from the report by adding a field to the dataset table? After a report refresh of course.

[@BIElite]

Hi Adam, yes there is but it would add a boatload of complexity. Instead of calling the built in Action to refresh the dataset, you would instead call the Power BI refresh endpoint directly. When doing so, there is a flag to be notified upon completion, which you could then do something with.

[@denisdeangelo6605]

Great video Parker! Thanks.. what kind of license do you need for this? at least ppu? or with PRO works well?

[@BIElite]

This works for Pro! You may need additional Power Automate licensing though.

[@innoscape8261]

Great and elegant video Parker ... as always!!! When I implemented the solution and tried to launch several updates, they were executed concurrently in the service (as in your example) and so the were throttled. Here is the error message: "The operation was throttled by Power BI Premium because there were too many datasets being processed concurrently." I have to find a workaround, other way it will be a very significant limitation for real life utilisation. Do you have any suggestion?

[@jordanhudson8695]

Great video, could be really useful for my organisation, one thing I can't seem to get past is when I choose custom value I don't see Power BI Dataset Refresh as an option, any advice? Thanks

[@tomaskavicky]

very handy, thanks

[@BIElite]

No problem, Tomas!

[@FJ-ow5lm]

Will this refresh give me any error if my source dataset schema changes (e.g adding new column or column name changes)?

[@sravankumar1767]

Nice explanation 👌, here we can see workspace in Dataset id, but unable see the workspace name and dataset name where is the option is available to see the workspace name an dataset name

[@BIElite]

Hi Sravan, I'm unclear what you're asking. We need to pass the IDs into the Power Automate visual for the refresh to work. If you have the workspace and dataset names in your dataset, you can visualize them however you want. Let me know

[@sravankumar1767]

@@BIElite we are preparing power bi documentation, we are getting data from dataflow and Azure devops , I need to found out workspace space name dataflow name , I am unable to found out , I checked in advanced editor here i can see workspace id and dataflow id , can please tell me the where is the option to find out workspace name and dataflow name

[@sravankumar1767]

@@BIElite can you please explain where the option is available to find out workspace name and dataflow name in power bi

[@r0b1]

Hi, This method required to buy power automate license? i mean, after expired trial version of automate.

[@tejasbrahmbatt5344]

maybe at the end of the refresh, the flow should send a notification to the person triggering refresh?