Bird
0
0

Which of the following is the correct Power Query step to change a column's data type to text?

easy📝 Formula Fix Q12 of 15
Power BI - Power Query Editor
Which of the following is the correct Power Query step to change a column's data type to text?
ATable.TransformColumnTypes(Source, {{"Column1", type text}})
BTable.ChangeType(Source, {"Column1", "text"})
CChangeType(Source, "Column1", Text)
DTransformColumn(Source, "Column1", TextType)
Step-by-Step Solution
Solution:

  1. Step 1: Recall Power Query syntax for changing column types

    The correct function is Table.TransformColumnTypes with a list of column-type pairs.

  2. Step 2: Match the syntax to the options

    Table.TransformColumnTypes(Source, {{"Column1", type text}}) matches the correct syntax exactly; others have incorrect function names or parameters.

  3. Final Answer:

    Table.TransformColumnTypes(Source, {{"Column1", type text}}) -> Option A

  4. Quick Check:

    Correct Power Query syntax = Table.TransformColumnTypes(Source, {{"Column1", type text}}) [OK]
Quick Trick: Use Table.TransformColumnTypes with column and type pairs [OK]
Common Mistakes:
  • Using wrong function names
  • Passing parameters in wrong order
  • Using quotes incorrectly around types

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Table and matrix visuals - Quiz 14medium Basic Visualizations - Card and multi-row card - Quiz 14medium Basic Visualizations - Why choosing the right visual matters - Quiz 8hard Data Cleaning with Power Query - Pivoting columns - Quiz 10hard Formatting and Design - Visual formatting options - Quiz 2easy Formatting and Design - Visual formatting options - Quiz 13medium Getting Data - Excel data import - Quiz 11easy Power Query Editor - Column operations (rename, remove, reorder) - Quiz 11easy Power Query Editor - Data type changes - Quiz 7medium Power Query Editor - Filtering rows - Quiz 13medium