Whats the default data type in Query Editor? symbil is ABC123

Hi StephenF 

"ABC 123" is of "any" data type, you can convert it to "text" under "Tranform"->"Data type".

 

When you load data into Power BI Desktop, it will attempt to convert the data type of the source column into a data type that better supports more efficient storage, calculations, and data visualization. For example, if a column of values you import from Excel has no fractional values, Power BI Desktop will convert the entire column of data to a Whole Number data type, which is better suited for storing integers.

 

For example, when i add a custom column without defining data type, it would show as a "any" type.

To avoid this and give proper type for columns, you could define data type when adding columns in power query.

https://excelgorilla.com/power-bi/power-query/define-data-type-custom-column/

 

Best Regards

Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.