The differences between Power Query and Power Pivot are explained as follows:
Power Query is all about analyzing data.
Power Pivot is all about getting and Transforming data.
Power Query is an ETL service tool.
Power Pivot is an in-memory data modeling component
