Can we do refresh flow with power automate for excel query in power bi ?

[hb0135]

Hello,
I have excel query taken from a server which have i have connected to power bi report and then publish to i have install the gateways to and they are working properly for automatic refresh but i want create a power automate flow for that report my concern does it work for  dataset like excel query and how?

BR
HB0135

[MFelix]

Hi @hb0135 ,

The Power automate can make the refresh of the dataset no matter what is the source however be aware that any refresh done by power automate is counted as part of the maximum daily schedulle refresh the service so if you have a pro license you get the total of 8 refresh.