I would like to perform some activity in a Excel Worksheet. Basically i want to Refresh Power Query (but not using Macro).
i.e. i need some automation which opens a Excel file and then goes to > Data Tab > Click Refresh All. Can i automate this activity using some recorder.