Errors while loading CSV file

[Anonymous]

Hi everyone, I'm new in Power BI and I'm trying to make some tests to see if Power Bi can replace our actual BI platform.

Once I loaded my .csv data, an error message appears saying there are more than 3 thousand errors.

When I go to see the errors, I see that some steps were applied to the data, as you can see in the picture, but the result is not what I expected, if I click on origin, I see the data in the right way... I don't know what to do to have my data in my model without those "automatic transformations".

[Anonymous]

Hi, 
The best way I found to "debug" errors after loading/refreshing data is to go into 'Edit Queries', and moving down step by step to see where the error occurs.
If you can add a screenshot of the applied steps on your query editor it will be easier to see the issue (the pic you attached are the steps on a mock table which PBI creates to display the errors, you can delete this folder after you fix the error).

Usually, when you load a .csv the only applied step is changing the column types according to the first 1000 rows, 
it could be that PBI chose the wrong type for a column which results in some rows ending up as errors.