Create a simple excel file that connects through power query to another excel file (small data).
Create inside this excel file a macro like this :
Public Sub Refresh()
Be sure that you approve the location of the file in excel so that macros can be run.
=> If I run the macro the data are refreshed and the table showing the data is up to date
=> If I use the new action Excel command > Run VBA macro it’s running in easymorph, macro is recognized because I have no error message, Output is empty. But If I go into my excel file to check the result I can see my data were not refreshed : the refresh did not work.