Forum Discussion
PDTaylor
Oct 22, 2021Copper Contributor
Excel Script - Refresh data
Hi, I have an excel file which has a data connection. I have been trying to get the data and associated pivot tables to refresh through a script but it doesn't seem to work fully. The script is ...
petraronald
Microsoft
PDTaylor Currently, pivot table refresh/Power Query refresh is not supported with Office Scripts. If you would like to see this feature in the Office Scripts feature-set, please upvote this request here: Enable Office Scripts to refresh Power Query queries · Community (microsoft.com).
Klaas Langhout
Oct 25, 2022Microsoft
Petra, any other suggestions for how with PowerAutomate/OfficeScripts to 'refresh' a query and pivot table ? Want to get to use PowerAutomate to send the latest info including a refresh.