Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Whats the default data type in Query Editor? symbol is ABC 123
I'm trying to convert it to a text type but i need to know what type of data it is
Solved! Go to Solution.
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.
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.
Hi @StephenF,
This is classified as Any Data Type, this is the default data type for PQ when it doesn't know.
Ricardo
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |