Forum Discussion
Anonymous
3 years agoNot applicable
Can I refresh Power Query with Office script?
I have some power queries in excel. This queries is linked with other excle files. I need to refresh this excel file with the office script to update the queries and reuse the query in ...
Syndicate_Admin
2 years agoAdministrator
I have the same problem. The script will say "the script is running ..." with no errors. But afterwards, the data query will remain the same and not refreshed. If I use the online menu -> data -> refresh all, the query will refresh just the same way as desktop app.
So the first reply below lnks to "Power Query refresh is generally available in Excel for the web", whilst it is true, it does not help in this situation if I need to schedule the Office Script containing this refresh command to fully automate the refresh. Anyone from Microsoft care to help with this?