I have a simple Power Query setup that I currently get the users to open Power Query change the source and refresh.
I would like to have a button that runs a macro to do the function of opening a dialog box to select the new source and apply it to the PQ and refresh the data model. Is this possible?
I tried recording a macro but nothing appears in the code.
Bookmarks