Contradicting wording in docs?

[KristianLN]

Hi

In the Power Automate Toubleshooting docs (here) it is listed that the workbook.refreshAllDataConnections do nothing in Power Automate flows. However, just below it is stated that the workbook.refreshAllDataConnections only refreshes PowerBI sources.
Isn't that contradicting?

In advance, thank you.

Best regards,

Kristian

[AlexJerabek]

Hi @KristianLN,

You're right that there's a mistake there. Workbook.refreshAllDataConnections refresh PowerBI sources in Power Automate. I'll remove that line from the other table.

[KristianLN]

Hi Alex

Thank you for your reply.
For some reason, I experience the behaviour mentioned in the obsolete table line, namely that the script runs successfully, returns no error but don't update the pivot table through Power Automate.
Only when I open the file and runs the script, the table is updated.
Any ideas what is going on?

Best regards,

Kristian

[AlexJerabek]

Thanks for reporting this. @michelleranmsft, can you please investigate?

[AlexJerabek]

Hi @KristianLN,

The current behavior for Workbook.refreshAllDataConnections in Power Automate is that it only refreshes PowerBI sources. For other sources, the method returns successfully but does nothing.

I'll update the documentation to better explain that.