I have an Excel file on SharePoint with data from an external data source (SQL Server). I want to setup an Office script to automate the refresh of the data and then trigger it via power automate. However, i am unable to get the data refreshed (even using the manual Refresh All button in Excel Online). It doesn't give any errors in the UI, shows as refreshing, but nothing changes.

I can refresh the data when i open in the Excel desktop app.

Any help on where should i check to get the data refreshed via Excel Online as well would be greatly appreciated?

TIA !