Forum Discussion
elisprague
Jun 05, 2024Copper Contributor
Refresh power query without opening file
Good afternoon, I would like to update my power query without having to be in the file to trigger the refresh. I have excel workbooks that live inside share point. I would like the power query to ...
SergeiBaklan
Jun 05, 2024Diamond Contributor
It depends. If new row of data is added by Power Automate, you may generate RefreshAll Office Script and run it also by Power Automate. But so far that works only if the data source is within same file. RefreshAll on web doesn't work with external sources.
Otherwise perhaps something with Power Shell which opens the file, refresh data and close the file after that.
elisprague
Jun 11, 2024Copper Contributor
Sergei, thank you for your response. I will look into office script tools.