Just tried connecting using Powerpivot. Most of the tables get you a 'invalid object name' error.

There are only a few that are query-able through Powerpivot =(