New in Excel for the web: Power Query Refresh & Data Source Settings for authenticated data sources

Hello! Those are wonderful news and I'm happy that the feature finally arrived 😊
What I'm currently still failing with, is to trigger an excel workbook refresh with keeping such a connecting using Office Scripts (finally from Power Automate end). So if I click the button (e.g. "Refresh All") in the excel workbook opened in Office Online - refresh works perfectly fine (= your new feature), but if I try to run a very simply office script (which should do the same) it fails (so no error, but de facto nothing updates). Here the script I used:

function main(workbook: ExcelScript.Workbook) {

  // Refresh all data connections

  workbook.refreshAllDataConnections();

}
Was there something "forgotten" or when will that work as well? 😬

Scenario is to update excels pivots in sharepoint via office functions (shared with certain communities; connected to an Azure SQL DB), event driven after the SQL data update took place (with using PowerAutomate in that case).