I'm not sure power pivot deals well with heterogeneous data sources. It rests on OLAP services which rely on a fixed star schemas in a data warehouse. Power piv

I'm not sure power pivot deals well with heterogeneous data sources. It rests on OLAP services which rely on a fixed star schemas in a data warehouse. Power pivot is just a front end for MDX(multi-dimensional expression) queries.