Forum Discussion
Chanleakna123
Post Prodigy
Post ProdigyMessage : Data format error, Can't convert to number
I really don't understand why BI shows the message Dataformat error. the source comes from Excel. it is okay when i load the data , once i unpivot it and Split the columns with Custom " ; " int...
If I am not mistaken, you just need to delete the Changed Type step after split in the Applied Steps. I always encounter this error and that always solves my problem.
mussaenda
Community Champion
Community ChampionIf I am not mistaken, you just need to delete the Changed Type step after split in the Applied Steps. I always encounter this error and that always solves my problem.