From the course: Excel Business Intelligence: Power Query

Unlock the full course today

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

Options for loading data in Excel

Options for loading data in Excel - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Query

Start my 1-month free trial

Options for loading data in Excel

“

- [Instructor] The last thing I want to cover before we get hands-on with some Power Query tools, are the data loading options, because these are very, very important. When you've connected to a source, you've applied whatever steps and transformations you'd like in the Query editor, your next step is to actually load that data from Power Query into Excel. You've got two options, you can load or load to. If you press load, by default Excel is going to try to dump that table and that data into a sheet, which is okay if you're dealing with very small data sets, but for the purposes of this course, we don't want to go that route. You've got a few options here. The first set of options is table versus connection only. Again, the table is going to store that data into a new or an existing worksheet. Because you're dealing with a worksheet, you're also dealing with the size limitations of a worksheet, not just about a million rows. Connection only, on the other hand, which we're going to be…

Contents