Forum Discussion
Post ProdigyMessage : Data format error, Can't convert to number
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.
Super UserHi Chanleakna123 ,
In PBI all the errors go to a separate folder with different tables when you do the upload of the model.
Make the upload of the model, and on the end it will send a error message that a number of erros where found and upload to the tables identified. Click on the link of that error message, and it will open the table of errors.
Once on the table you can see what cell have the error. Be advise that if you want to see the errors details you need to click on the cell but not on the error text itself, the description of the error will appear on the bottom of the screen.
then just need to go back to your original table and correct the error, normally you need to change formats or something similar.
Regards,
MFelix