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. In other words, it kills the rest of the process because it encountered that "critical" error.
So far, I've been able to load these tables:
but none of the actual AW database. The views are loading just fine tho like vSalesPerson.
Could it be something with the access that the user has for those tables?