|By Jayaram Krishnaswamy||
|January 3, 2014 11:40 PM EST||
The variety of data sources that Power Query can connect to manage is much wider than that of Power Pivot including the social media created data like Facebook and unstructured data.
Power Pivot has a more powerful analytical role than Power Query which you can easily make out by just looking at the user interfaces.
However both of them are downloaded as add-ins for MS EXCEL 2010 or 2013 as shown (MS EXCEL 2010 in this case).
You may follow this link for more details: