Power Automate - Dataflows Refresh

[Anonymous]

Hey - I have created a few dataflows. I have scheduled these to run periodically.

I have then used these dataflows in excel to create reports. The user can refresh in excel and pick up from the last dataflow scheduled refresh.

I am now looking for a solution to use power automate to allow the user within excel to refresh the dataflow on an ad-hoc basis.

(Scenario being that they have posted some data and want to ad-hoc see the report without waiting for the next scheduled refresh - and I do not want to add the complication of them clicking refresh in power bi)

[Anonymous]

Hi @Anonymous ,
Does the information provided by lbendlin  help you solve your problem? If it helps, please accept the responses you find helpful as solution.

Best regards,
Albert He

[Anonymous]

no, it doesn't

[Anonymous]

Super small user base, who know what they're doing...

[lbendlin]

Introducing Microsoft Flow integration in Excel - Microsoft Power Platform Blog

[lbendlin]

VBI.  (very bad idea)  How do you prevent your users from smashing that refresh button repeatedly?