Hi all,
I need to refresh the Power query connections in background in an excel file saved in Share Point. I tried to build a flow in Power Automate Web (I don't have the license for the desktop) but despite the succesfull test, the refresh didn't run.
I created a Script in the file excel that refershed all the data and it was recalled in the flow, everything goes smooth, but at the end the file is not updated.
I read somewhere that Power Automate Web doesn't support this kind of fuctionality, is it correct? Do I need the Desktop version? Is there any other way to automatize this action?
Thanks