Auto-changing datatype option in the Power query editor

[Vallirajap]

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..!

[m_dekorte · Accepted solution]

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]

Hi @m_dekorte,

Thank you for your reply.