I started using the new Office Scripts in Excel on the web. I was wondering if anyone knows if it´s possible to Refresh the Queries and Connections of an Excel Workbook saved on SharePoint Online.
I would like to run the script utilizing a Scheduled Flow in Power Automate.
There seems to be a workbook.refreshAllDataConnections() Method in typescript (when writing in the Script Editor) but it doesn´t really do anything.
Thank you in advance for your help!
The Power Query refresh is not supported for the time being. Regarding other types of connections, it is not yet detailed out in the API. There's a docs bug open to get clarification on what types of connections are supported.
Docs bug: https://github.com/OfficeDev/office-js-docs-reference/issues/805