Hi Community,

i want to automate a power query connection. In this case i use the following office-script:
Please Login or Register  to view this content.
When I run the script manually, it does what it's supposed to do.
But when I create a cloud flow in PowerAutomate and want a scheduled execution of this script, it looks like it at first glance, but it doesn't work.

I found an article explaining that the workbook.refreshAllDataConnections() function is not supported by Power Automate.

Is there another way to update the external data connections?

Many thanks for your help