My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

You are here: Home / Automate Refresh Power Query|Power Query|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Automate Refresh Power Query
Avatar
Mark Smith
Member
Members
Level 0
Forum Posts: 7
Member Since:
February 19, 2021
sp_UserOfflineSmall Offline
1
August 3, 2022 - 10:12 pm
sp_Permalink sp_Print

Hi, what are the options to refresh a power query in an excel spreadsheet in the background? I have a power query that is reading prices and formatting the table for uploading into another system. I want to automate it all, right now I have to open the excel and ‘Refresh All’ and then save it, so my next program can read the new format. I think Power Automate is an option for this, but I also think this requires a premium license? Before I go down that route I wondering if there is a refresh option that I can schedule either in Excel itself or via Windows Scheduler? Or another way? Thanks for any advice on this.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4438
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
August 4, 2022 - 9:58 am
sp_Permalink sp_Print

Hi Mark,

Power Automate would be the solution. There is a free Power Automate Desktop tool you can use, but the PC would need to be running for it to open the file and refresh. 

I'm not aware of any way with Excel or Windows Scheduler.

Mynda

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Velouria, Dieneba NDIAYE, Ben Hughes, Dario Serrati, Jay Soysa, Marco Marques, Christopher Anderson, Natasha Smith, dectator mang, Oluwadamilola Ogun, yashal minahil
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 870
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
A.Maurizio: 202
Jessica Stewart: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
yashal minahil
Oluwadamilola Ogun
Yannik H
dectator mang
Francis Drouillard
Orlando Inocente
Jovitha Clemence
Maloxat Axmatovna
Ricardo Freitas
Marko Meglic
Forum Stats:
Groups: 3
Forums: 24
Topics: 6200
Posts: 27181

 

Member Stats:
Guest Posters: 49
Members: 31858
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen