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,
My field type was set up as numeric and then I changed to text but I am still getting error status.
I have tried to use the transform > clean option but does not get rid of error status for the following type of values I am getting errors LB/TY/642/479 or 12345 774
Is there a way to allow these type of values?
Thanks
Solved! Go to Solution.
Changing it back to text will only work if it is the first data type change in all queries referencing the column. Swim back upstream and find the first instance where the data type is changed to numeric, and change it there.
Changing it back to text will only work if it is the first data type change in all queries referencing the column. Swim back upstream and find the first instance where the data type is changed to numeric, and change it 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.