KEMBAR78
Power Query | PDF
Scribd
Upload
228 views4 pages

Power Query

Power Query is an extract, transform, and load (ETL) tool in Power BI used to clean and combine data from different sources by performing operations like merging, joining, adding or removing columns/rows, transposing, and pivoting data. It uses the M query language to manipulate data through equations and publish updated datasets. Power Query can be opened by selecting the Transpose option after connecting data or by going to the More option in the Field section and selecting Edit Query.

Uploaded by

Rajasekhar Kolla
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
228 views4 pages

Power Query

Power Query is an extract, transform, and load (ETL) tool in Power BI used to clean and combine data from different sources by performing operations like merging, joining, adding or removing columns/rows, transposing, and pivoting data. It uses the M query language to manipulate data through equations and publish updated datasets. Power Query can be opened by selecting the Transpose option after connecting data or by going to the More option in the Field section and selecting Edit Query.

Uploaded by

Rajasekhar Kolla
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Power Query

• Power Query (for data mash-up and transformation)


• Power Query is an (Extract, Transform, Load) Engine in power BI

• Power Query is used to –


• Collect and combine data (merge, join, etc.) from different spots
• Add and remove columns of data
• Add and remove data row
• Reshape data (transposing, pivoting, un-pivoting and other innovative ways)
• Compose equations to manipulation of information
• Publish updated datasets
 How to open power query?
There are three way to enter into power query
1. After data connection you can see below window from there select Transpose option

2.

3.
- In filed section go to
more option – select
edit query
Cont.
 Power Query is a M formula based language its a case-sensitive developed by Microsoft

• M is informal name of Power Query Formula Language.


• M stands for Data Mashup, some say stands for Data Modeling.
• all the code elements necessary to define a dataset. A let expression is made up of a let statement and an
in statement, as shown in the following syntax:
Few of the data transformation using power query

• First Rows as headers


• Remove column
• Replace the values
• Change data type
• duplicates columns and tables and remove duplicates
• Split Column
• Combine Two columns
• Creating Index column

And many

You might also like