Forum Discussion
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...
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
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
Hi m_dekorte,
Thank you for your reply.
