Forum Discussion
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 refresh when a new row of data is added to the source data. The file where the power query will live will not be opened everyday. I would like this process to occur in the background without having to open the file. Please let me know if you have a solution.
2 Replies
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.
- Sergei, thank you for your response. I will look into office script tools.
