From the course: Excel Power Query Tips and Techniques

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Change load-to destination

Change load-to destination

From the course: Excel Power Query Tips and Techniques

Start my 1-month free trial

Change load-to destination

“

- (Instructor) In this workbook, we've got a lot of queries, let's check it out. We've got our source data over here. The detail of manager's airports, airport cities, lots of queries. Now we want to look at, what happens when we need to change the load-to destination. Notice in the queries and connections pane, the detail query is loading as a connection only. What if I do want to see that on a worksheet? I go over, highlight it, right-click, load-to. Now, I can load it somewhere other than as a connection. So, let's put it as table, on a new worksheet, okay. And there it is, and notice in the queries and connections pane, it's showing as 2 rows loaded. Next, what if something is loaded that I want as a connection only? That's easy. Go to the worksheet, right-click, delete, it will warn me and ask me if I want to continue. Yes, go ahead and delete. Now it's back as a connection only.

Contents