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!