Power Platform Community Forum Thread Details

Hi everyone,

I'm working on a small project for a dashboard created in a Excel file. The file is saved in a SharePoint and I'm trying to automate the refresh of the tables (built with Power Query) via Power Automate Cloud flow.

I created a script in Excel that basically run the "Refresh all".

In Power Automate cloud flow, I add the step "Run the script" and the test works fine, however when I open the Excel file, I have noticed that the tables are not updated.

Is there a way to understand how to correctly set up in Power Automate cloud flow the different steps to complete the refresh of Power queries? Is there any limitation that I'm not aware of?

Thank you in advance!

Categories:

Building flows