Forum Discussion

Ankit137's avatar
Ankit137
Copper Contributor
Nov 17, 2025

Power query refresh using script

I am trying to automate a power query refresh using power automate. The flow seems to be working fine, but the excel in itself isn't refreshing the output tables. The script I am using is this

function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); }

I can see the updated query in the query editor, but not in the output tabs within the excel.

Resources