function main(workbook: ExcelScript.Workbook) {
workbook.refreshAllDataConnections();
}
If im using directly in Excel, it works fine, but while running in Power Automate, the flow seems to be ok but the query is not refreshed...
I see some people saying that this its not supported by Automate, is there a workaround to make this happen?