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.
+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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.