Column operations (rename, remove, reorder) in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does renaming a column in Power BI do?

Renaming a column changes its displayed name in reports and data views without altering the data inside it.

beginner

How do you remove a column in Power BI's Query Editor?

You select the column and choose 'Remove Columns' to delete it from the data set before loading it into the report.

beginner

Why reorder columns in Power BI?

Reordering columns helps organize data logically, making reports easier to read and understand.

beginner

True or False: Removing a column in Power BI Query Editor deletes the data permanently from the source.

False. Removing a column only affects the data loaded into Power BI, not the original data source.

beginner

What is the easiest way to rename a column in Power BI Desktop's Data view?

Double-click the column header and type the new name directly.

Which Power BI feature lets you remove columns before loading data?

A Dashboard

B Report View

C Query Editor

D Data Model

Query Editor is where you clean and transform data, including removing columns.

How can you reorder columns in Power BI?

A Drag and drop columns in Query Editor

B Right-click and select 'Reorder' in Report View

C Use DAX formula

D Change column order in source file only

You can drag and drop columns in Query Editor to reorder them before loading.

What happens if you rename a column in Power BI?

A The original data source column name changes

B The column is deleted

C Data inside the column changes

D Only the column name changes in Power BI

Renaming changes the column name only inside Power BI, not the source data.

Which view in Power BI Desktop allows you to rename columns by double-clicking?

A Dashboard View

B Data View

C Model View

D Report View

Data View lets you rename columns easily by double-clicking the header.

Removing a column in Power BI Query Editor will:

A Remove it only from the loaded data

B Delete it from the original data source

C Hide it temporarily in reports

D Create a backup of the column

Removing a column in Query Editor removes it from the data loaded into Power BI, not the source.

Explain how to rename, remove, and reorder columns in Power BI Query Editor.

Think about the steps you take in Query Editor to clean and organize data.

Why is it important to reorder columns in your Power BI data before building reports?

Consider how you arrange items on your desk to work faster.