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

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.