Which of the following is a feature of Power Query?
Change column headings so the new name appears in the File list of a PivotTable
Change the raw data
Build relationships between tables
Uses Visual Basic to create steps for import Confirm
The correct answer and explanation is :
The correct answer is:
Change column headings so the new name appears in the Field list of a PivotTable.
Explanation:
Power Query is a powerful data transformation tool available in Microsoft Excel and Power BI. It allows users to extract, transform, and load (ETL) data from various sources without altering the original data.
One of Power Query’s essential features is its ability to rename columns in the data model. When you load transformed data into Excel or Power BI, the new column names appear in the Field List of a PivotTable, making it easier for users to analyze and interpret data. This feature is particularly useful when dealing with datasets where column names are unclear, inconsistent, or not user-friendly.
Why the other options are incorrect:
- Change the raw data – Power Query does not modify the original data source. Instead, it applies transformations to a copy of the data within the Power Query Editor, ensuring that the raw data remains intact.
- Build relationships between tables – While Power Query can merge or append tables, it does not create relationships between tables. Relationships between tables are managed in the Data Model within Excel’s Power Pivot or Power BI’s Relationship View.
- Uses Visual Basic to create steps for import – Power Query does not use Visual Basic (VBA) to create steps. Instead, it records transformation steps using a language called M (Power Query Formula Language). These steps are applied automatically whenever the data is refreshed.
Thus, the key feature that Power Query provides in this context is renaming column headings, which ensures that updated names appear in PivotTables, making data analysis more intuitive.