Load Power Query Directly to Power Pivot with Excel 2010
When you write a Power Query workbook in Excel 2013, you are given 4 choices of what to do with results. One of the choices is to load the resulting query directly to the Power Pivot data model. This choice does not exist in Excel 2010. It is reasonable therefore to think that you must first send the results to an Excel table and then load the table to Power Pivot, but that is actually not the case - there is a way to do it, read on.