Forum Discussion
Power query refresh using script
I am trying to automate the power query refresh using power automate. Change in a folder triggers multiple scripts. All the scripts seem to be working fine, but the final script to refresh the connections, to show updated query results in the various tabs is not working.
function main(workbook: ExcelScript.Workbook) { // Refresh all data connections workbook.refreshAllDataConnections(); }
what might be different about this?
thanks!
2 Replies
Latest updates could be introduced here New in Excel for the web: Power Query Refresh & Data Source Settings for authenticated data sources | Microsoft Community Hub , see in comments.
Yes, so far this functionality is not supported.
I wonder whether you are seeing the same issues as reported in this forum: https://learn.microsoft.com/en-us/answers/questions/1250098/workbook-refreshalldataconnections()-is-not-suppor
