Skip to content

Office Scripts: Refresh all Connections working as 'Recorded Action', but workbook.refreshAllDataConnections() not working when action is converted to code script #834

Description

@conordev24

Environments
Excel Online
Power Query Datasource

Issue
When I record a script and click on Refresh All Connections and run the script it successfully refreshes my Power Query Datasource:
Image

However, if convert that same script into code, it states that it ran successfully but it doesn't update the Power Query Datasource:
Image

I've read this may or may not be a limitation, just wanted it confirmed as I've found it strange it can be automated, but not called from code. Thanks for your help.

Metadata

Metadata

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions