Forum Discussion
gtamir
Post Patron
Post Patron#NAME?
Hi, After I loaded Sales table I got lot of errors in column "ProductName". The column in type TEXT. I went bake to the original excel file and found that there is a special character like +. I lo...
zoloturu
Memorable Member
Memorable MemberHi gtamir,
Most of the time when you import data into the report Power BI automatically creates data type conversion step called 'Changed type'. You can adjust it, or even remove it and then apply your custom one.
Can you remove it via Advanced editor or using steps pane? And show us result with screenshot?
Regards,
Ruslan
gtamirPost Patron
Post PatronFunny. This file is an append of 6 files.
I erased it, deleted the "change type" step as you suggested in all 6 files, and close and apply. No errors.
Now I appended the 6 files and I have 43 errors of the same kind (insted of a few Thousands before).
I also trimed and cleand the column.
any idea?