Bird
0
0

While in Data View, you notice a column shows incorrect data types. What is the best way to fix this?

medium📝 Formula Fix Q7 of 15
Power BI - Basics and Architecture
While in Data View, you notice a column shows incorrect data types. What is the best way to fix this?
AChange the data type in Data View directly
BModify the data type in Power Query Editor and refresh
CCreate a new calculated column with correct type in Model View
DDelete the column and reload the data
Step-by-Step Solution
Solution:

  1. Step 1: Identify where data types are set

    Data types are best set in Power Query Editor before loading data.

  2. Step 2: Apply the fix

    Change the data type in Power Query Editor, then refresh to update Data View.

  3. Final Answer:

    Modify the data type in Power Query Editor and refresh -> Option B

  4. Quick Check:

    Power Query Editor sets data types before loading [OK]
Quick Trick: Fix data types in Power Query Editor, not Data View [OK]
Common Mistakes:
  • Trying to change data type directly in Data View
  • Creating calculated columns unnecessarily
  • Deleting columns instead of fixing types

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Power BI Quizzes
Basic Visualizations - Pie and donut charts - Quiz 10hard Data Cleaning with Power Query - Trim and clean text - Quiz 8hard Formatting and Design - Visual formatting options - Quiz 8hard Getting Data - Why connecting to data sources is the first step - Quiz 3easy Getting Data - SQL Server connection - Quiz 14medium Power BI Basics and Architecture - First Power BI report - Quiz 4medium Power BI Basics and Architecture - Power BI vs Tableau vs Excel comparison - Quiz 11easy Power BI Basics and Architecture - Power BI vs Tableau vs Excel comparison - Quiz 6medium Power Query Editor - Power Query interface overview - Quiz 4medium Power Query Editor - Column operations (rename, remove, reorder) - Quiz 12easy