Forum Discussion

Jun_Wang's avatar
Jun_Wang
Advocate I
6 years ago
Solved

csv file import issue

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

Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    6 years ago

    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.⚡

4 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    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's avatar
      Jun_Wang
      Advocate I
      6 years ago

      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's avatar
        amitchandak
        Super User
        6 years ago

        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

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    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.