Hi,
I use Power automate to refresh an excel table that is connected to Power BI every day.
This is via a 'Run Script' prompt that refers to a script containing Workbook.refreshAllDataConnections().
This has always functioned very well. However, as of today, I receive the below error.
Has Microsoft changed the possibility to use Workbook.refreshAllDataConnections() or might there be something else?
The error message:
"We were unable to run the script. Please try again.
Runtime error: Line 5: Workbook.refreshAllDataConnections() is not supported in Power Automate.
clientRequestId: 566bd94c-36fd-4090-aa5c-cc47459f3b53"