Forum Discussion
csv file import issue
Jun_Wang when you import CSV files, it probably has a change type step which it auto-detects and maybe remove that step and correct set the data type of your columns. sometimes first 100 rows of data is different than other values in the columns and can lead to errors.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation! ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Jun_Wang when you import CSV files, it probably has a change type step which it auto-detects and maybe remove that step and correct set the data type of your columns. sometimes first 100 rows of data is different than other values in the columns and can lead to errors.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation! ⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Appreciated your quick reply. Sorry I should have asked this further question togerher. Why there is no errors if I conver the same csv file to xlsx and import in?
Jun_Wang , you can check it like this.
Go to the table in the edit query /data transformation mode. Right-click and open advance editor , check the data type in case of both excel and csv. Excel might have taken one column as text or some data type where is not giving error.
In Data transformation mode, you should also see the error message with the yellow background
