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.
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. Read More