Power Query Editor

Learn how to clean, transform, and prepare data using the Power Query Editor. Master data connections, transformations, M functions, and best practices to shape raw data into structured datasets ready for analysis in Power BI and Excel.

🔍

No topics found matching your search.

🔄 Data Transformation

Replace Value

Use the Replace Values feature in Power Query Editor to substitute existing values in a column.

Transpose a Table

Rotate a table 90 degrees by converting rows into columns and columns into rows.

Split Column in Power Query Editor

Split a single column into multiple columns using delimiters or positions.

Duplicate Column in Power Query Editor

Create a duplicate copy of an existing column for further transformations.

Remove, Count, Reverse Rows

Learn how to remove rows, count rows, and reverse row order inside Power Query.

Merge, Remove, Rename, Choose and Go to Columns

Manage columns by merging, renaming, removing, and selecting specific columns.

Conditional Column in Power BI

Create new columns using conditional logic similar to IF statements.

Standard Function in Power BI

Use standard transformation functions available in Power Query Editor.

Promote and Demote Headers in Power BI

Convert rows into column headers or revert headers back into rows.

Index Column in Power BI

Add sequential numbering to rows for indexing and referencing.

Pivot Column in Power BI

Transform unique row values into columns for reshaping datasets.

Unpivot Columns in Power BI

Convert multiple columns into attribute-value rows for normalized data.

⚙️ Query Management

Rename a Query in Power BI

Rename queries in Power Query Editor to improve organization and clarity.

Delete a Table (Query) from Power BI

Remove unwanted queries from Power Query Editor.

Duplicate the Table (Query) in Power BI

Create duplicate queries to reuse transformations on different datasets.

Organize Queries into Groups

Structure multiple queries into groups for better project management.

Creating and Managing Parameters

Create reusable parameters for dynamic query transformations.

Reference a Table in Power Query Editor

Create referenced queries that inherit transformations from the original query.

Managing Loading of Queries

Control which queries load into the Power BI data model.

📊 Data Quality and Profiling

Column Quality in Power Query Editor

Analyze data quality indicators such as valid, error, and empty values.

Column Distribution in Power Query Editor

Visualize value distribution and detect outliers in datasets.

📂 Combine Files or Sheets

Append Queries in Power Query Editor

Combine multiple tables by stacking rows from different queries.

Merge Queries in Power Query Editor

Join multiple tables based on matching columns.

Folder Connector in Power Query Editor

Import and combine multiple files from a folder automatically.