Home » Power BI » Power Pivot, Power Query and Power View in Power BI

Power Pivot, Power Query and Power View in Power BI

Power query Power View Power pivot

In this blog you will understand about Power Query, Power Pivot & Power View in Power BI Desktop.

What is Power Query?

It is ETL component that helps us to extract, transform and load the data into Power BI desktop.

Power Query Editor

Power Query Editor

Power Query provides many transformation options in order to transform your data, some common transformations are-

  • Group by
  • Use First Row as Header
  • Transpose
  • Pivoting, Un-pivoting
  • Reverse Rows, Count Rows
  • Change Data Type
  • Rename Column, Remove Column & Split column
  • Apply Statistical Function, Math Functions & Trigonometry function
  • Keep Top Rows/ Keep Bottom Rows
  • Combine & Join Data(Merge Queries, Append Queries)





With Power Query you can extract data from multiple data sources like(databases, files, web pages, Azure etc.)

Get data into Power BI

Get data into Power BI

What is Power Pivot?

Power Pivot is the component where you can setup a relationship between Tables/Queries loaded into the data model.

It is calculation engine of Power BI. It is used to model complex business data, calculate data that needs to be displayed in the area of the value field in the Pivot charts/tables.




You can use the Data Analysis Expression (DAX) language to inform the Power Pivot about the various calculations you require.

Power Pivot set relationship

Power Pivot set relationship

What is Power View?

With the help of Power view, you can create interactive charts, graph, maps and other visuals.

Power View in Power BI

Power View in Power BI



Refer more Power BI Post – Power BI

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.

Leave a Reply