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.
Hi,
I have imported some data from excel and I can see that one of the columns appears to have an error.
WHen I selected the column it says - we couldnt covert to number.
This column has values as shown below.
1.11
2.09
XX21
3.11
RE12
I changed the column data type to text but still the error remain. Is there a way to manage this? I dont have any analysis on column, I will use this a text field.
Thanks a lot.
Solved! Go to Solution.
You likely still have the step in there where this got converted to a number. Likely it is the first Changed Type step in your query. You need to change the data type up there. So, click on your step above your first Changed Type step and switch the column to Text. It should ask you to replace the current step. Say yes.
You likely still have the step in there where this got converted to a number. Likely it is the first Changed Type step in your query. You need to change the data type up there. So, click on your step above your first Changed Type step and switch the column to Text. It should ask you to replace the current step. Say yes.
Thanks @Greg_Deckler , it works a treat!
Thanks @az38 , I had to change it where it was converting it to a number as @Greg_Deckler mentioned.
Hi @Anonymous
try to set column AS text before the step that automatically set is as number
Go it edit query/transform data and try to change data type there.
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |