Forum Discussion

DavePowerBI's avatar
DavePowerBI
Frequent Visitor
3 years ago
Solved

Error on values containing Alphanum and special characters

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...
  • MattAllington's avatar
    3 years ago

    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.