Office Scripts can't refresh most data when run in Power Automate. Most refresh methods, such as PivotTable.refresh
, do nothing when called in a flow. Workbook.refreshAllDataConnections
only refreshes when PowerBI is the source. Additionally, Power Automate doesn't trigger a data refresh for formulas that use workbook links.
The following methods do nothing in a script when called through Power Automate. They still return successfully and don't throw any errors.
Class | Method |
---|---|
PivotTable | refresh |
Workbook | refreshAllPivotTables |
Worksheet | refreshAllPivotTables |
The following methods act differently in Power Automate flows than they do when run through Excel.
Class | Method | Power Automate behavior |
---|---|---|
Workbook | refreshAllDataConnections |
Only refreshes PowerBI sources. For other sources, the method returns successfully but does nothing. |
Ellis Karim
Blog: https://elliskarim.com
|