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.
I can't believe Power Query doesn't have its own schedule feature. It is pretty critical in an extract/transform tool.
i agree being able to refresh an excel power query is a must