Forum Discussion
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 ...
Thanks for your reply v-jingzhang,
Here you have mentioned that "This seems not possible with Power Automate Cloud currently. "
But there is a link "Power Query Refresh is now generally available in Excel for the web (microsoft.com)" As per the understanding, with the web excel menu, I can refresh the power query connection. But there is no office script to refresh the connection.
I am working with the excel batch process by Takolota. Let's see whether I can refresh power queries with this method or not.
Hi Mohsin,
Did you find the solution to this?