Forum Discussion
Solved
Support Needed - Cannot get query to refresh!
Hi All I have tried so many scenarios - I have a query in excel that I have set up to refresh automatically. However it will not update. The file is in sharepoint, Then I have tried a Scrip...
If you want to auto-refresh a Power Query, your best bet is to use Power BI instead. You can schedule the refresh in the cloud, people can still use Excel with it with the "Analyze in Excel" feature or just via tables in the report.
Can you open the file manually and refresh the Power Query queries? If so, then the issue is not with Power Query.
Is it possibly a credentials issue? What account is your Power Automate running under? Is it you?