11
Hi Experts,
I am trying to use Power automate to refresh an excel powerquery connections and update data present in the excel tables. The source is connection to the folder containing different .xls files. I am trying to schedule this refresh once in a day. Is there any way we can do it?
@manuelstgomes & @Haithamalsheikh
You can try the routes of auto-refreshing the query on opening the workbook or using Power Automate Desktop
Or if neither of those are sufficient & your query is relatively simple, then you could try doing a batch upsert & batch delete to refresh each table…
Batch Upsert
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706
BatchDeleteSync template
https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Delete/td-p/1634375
i have the same issue can anyone solve it?
Hi @Srikanth08
But not automatically using Power Automate right?
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
Yes i have gone the traditional way of writing VBA code to open the powerquery file and refresh the connections.
Hi @Srikanth08
I don't think that's possible, but if it is, I would love to know how because I have the same requirement :).
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel
#1
WarrenBelz
146,702
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,015
Most Valuable Professional
Share
Report
All responses (
Answers (
