csv file import issue

[Jun_Wang]

Hi there,

I have a csv file. When import it from power bi desktop, there'll be 15 errors. However, there will be no errors if I open that csv file and load (from table) to power query. I even tried open a excel and get this csv file from "get data-csv data", then errors come again. 

I guess this might be something to do with the csv file encoding but unsure about it. My temporary solusion is to convert the csv file to xlsx and import to power bi desk. However, I'd like to understand why this was happaning. Could anyonre please shed some light on it?

Very much appreciated your help.

Jun

[v-lionel-msft]

Hi @Jun_Wang ,

Do you mind showing the error message?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@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]

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?

[amitchandak]

@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