Forum Discussion

Vallirajap's avatar
Vallirajap
Resolver III
2 years ago
Solved

Auto-changing datatype option in the Power query editor

Hi Everyone, 

 

I have one doubt in the Power Query editor: is there any option available for changing the column datatype automatically based on the column value? 

 

I know that we use a conditional column to reach the goal. Apart from that, are there any keys?

 

Thanks in advance..!

Data Protection
Need Help
Show and Tell
Tips and Tricks
  • m_dekorte's avatar
    m_dekorte
    2 years ago

    Hi Vallirajap,

     

    There is an option to change a column's data type automatically. It is located on the Transform tab and called "Detect Data Type". However, there is a caveat: because it only scans the top 200 rows, you will always have to validate that it guessed the types correctly...

     

    Read all about it here.

     

    I hope this is helpful

2 Replies

  • m_dekorte's avatar
    m_dekorte
    Resident Rockstar
    2 years ago

    Hi Vallirajap,

     

    There is an option to change a column's data type automatically. It is located on the Transform tab and called "Detect Data Type". However, there is a caveat: because it only scans the top 200 rows, you will always have to validate that it guessed the types correctly...

     

    Read all about it here.

     

    I hope this is helpful