1 Attachment(s)
PQ - Choose power query table destination range & sheet
(question from the web)
Quote:
I'm fairly new to using Power Query.
I'm pulling data from a website using the data "from web" method.
I'm putting the data into a table.
Everything's working well - the query gets the data (passing my credentials etc) and puts it into a sheet, as a table.
The problem I have, is that I don't appear to be able to select the destination; I want to put the fetched data into a particular sheet - alongside another table from a separate web query, but the query has created it's own sheet, and I don't appear to be able to change that anywhere.
- delete this new sheet with query table
- select destination sheet and then select place (cell eg D2) where you want your query table start
- next Data tab - Show Queries (or Queries and Connections)
- Right click on your Query table - Load to and then
- Attachment 3527
that's all folks