Interesting enough, that was done through the Powerpivot import tables wizard but...If instead of using the Wizard I create a simple query like:

SELECT *

FROM

Sales.SalesOrderDetail AS SalesOrderDetail

Then it retrieves...

pretty hard to tell since what Powerpivot does is that if it encounters just 1 that gives an error it gives you an error for the rest of the tables....

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 =(