Forum Discussion
Close and Load Location Power Query
I am trying to import data to excel from a json file using power query. The data is accessed, formatted, and placed correctly but every time it places the resulting table in a new sheet. Is there a w...
phwilson17 Unfortunately you can not yet set the load location in Excel for the Mac. Close and load will default to a new sheet for each query. You can't even select "Connection only".
But, once the table is loaded, select it and press ctrl-X (cut) and paste it in the location when you want it to be.