cancel
Showing results for 
Search instead for 
Did you mean: 

Refresh Power Query connections in an Excel file.

It would be great to have an action that would refresh connections inside an Excel file with Power Query.


This would allow some shared files to be regularly updated without having to manually open the file and refresh.

 

 

 

Status: New
Comments
sdgdfgd
Regular Visitor

+1

Jgreen01
Helper I
+1
NicolasArena
Regular Visitor

+1

KeplerSorrenson
Regular Visitor

+1

BharrisQM
New Member

+1 to this topic because MS needs to understand that many businesses create elaborate EXCEL apps that generate complex data sets for ingest. Without an automated way of refreshing the data it is a 100% MANUAL daily task of opening each Excel document just to refresh data. You can use fancy tricks with PowerShell and VMs to get around this (to a degree), but the fact remains that Excel is a powerful too in the MS Power stack for data modeling that needs to have a way of automating its data refreshing. So in my perspective this is a no-brainer feature that needs to be prioritized at the earliest opportunity. Thanks!

erincannon1
Frequent Visitor

Please?

ScottMeyers
New Member

+1

sdgdfgd
Regular Visitor

+1

EmDżej
New Member

+1

JandroH
Regular Visitor

+1