Understanding Close & Load To
When you are done with your Power Query data ingestion and transformation, you will have to load the transformed data for access within Excel’s main application area. You can access the load feature under the Home menu. You will be presented with Close & Load and Close & Load To.... See the following screenshot of the Close & Load options:
Figure 4.62 – Close & Load in Power Query
You might wonder what the difference is between Close & Load, and Close & Load To.
Close & Load loads the transformed data using your default settings. If you have not altered the default settings since Excel’s installation, it will load each table into a separate Excel sheet and also into the data model. The data model is essentially Power Pivot, which we will discuss in Chapter 5, PivotTable and Power Pivot.
Close & Load To presents you with all the options for where you can load the...
