The process where Power Query automatically analyzes column values to assign appropriate data types like text, number, or date during data import.
ลองใช้กับ AIData type detection occurs when Power Query scans the initial rows of a dataset to infer the most suitable format for each column. This automation helps ensure that subsequent calculations and transformations are performed correctly by preventing data type mismatches.
If a column contains '100', '200', and '300', Power Query will detect these as Whole Numbers rather than Text, allowing for immediate mathematical operations.
Yes, you can turn this off in the Power Query Editor options under 'Data Load' settings to prevent unwanted automatic type changes.