QUERY tab. One important thing to note in the Query Settings task pane is the Load to data model button. If you click that, once complete, you won’t get any fancy message boxes, just a simple text display.

What’s the benefit of this? Well you get all of this data in its glory into PowerPivot!

Update!

Since this is a preview, expect updates. In fact, there is already an update available (blogged about here). A super nice feature built into this add-in is the update feature. If you look at the DATA EXPLORER ribbon tab, look to the Options group, there is a button that says Update. If that is grayed out, no update is available. The only time that becomes active is if there is an update available. So really the only thing you need to do is ignore that button until it’s enabled. You’ll be taken to the website for downloading the new version (currently as an MSI install file). You will have to quit all Excel sessions to install it.