Forum Discussion

Vallirajap's avatar
Vallirajap
Icon for Resolver III rankResolver 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 conditi...
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

m_dekorte's avatar
m_dekorte
Icon for Resident Rockstar rankResident 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

Vallirajap's avatar
Vallirajap
Icon for Resolver III rankResolver III
2 years ago

Hi m_dekorte,

Thank you for your reply.