You’re offline. This is a read only version of the page.
Announcements
Hi,
I have a set of queries that read excel spreadsheets into power query, then modify and merge the data.
Is there a way in a flow or power automate to force the queries to refresh, say when one of the files is changed?
If I set the queries to refresh on open, when I open the excel using a flow, will that force a refresh?
If not, when I set the connections to auto refresh every half hour or so, will these refreshes work if the excel with the queries is just sitting saved in the folder?
Thanks for any guidance you can give me with this, it's all very confusing, and I'm pretty desperate to get this automated without resorting to an SSIS package or python or something like that.
Thanks for any help you can give me!~!
Share
Report
All responses (
Answers (
522
