Forum Discussion

pistonss's avatar
pistonss
Frequent Visitor
8 years ago

20 rows loaded. 20 errors !!

Hello all,   I am very new to Power BI and need help for this   I have the error message when refreshing the data '20 rows loaded. 20 errors' as below:   And when I clicked 'view error' it ...
pistonss's avatar
pistonss
Frequent Visitor
8 years ago

Hello all,

 

I am very new to Power BI and need help for this

 

I have the error message when refreshing the data '20 rows loaded. 20 errors' as below:

error message

 

And when I clicked 'view error' it brought me to this:

 

Error in query

 

I have no idea what I have done wrong. The way I usually upload my data is through a .csv file which I am sure that it is now comprising of columns and column names the same as before there's an error message coming up.

 

Can anyone tell me just by looking at this what are my problems? Also any tips to interpret the query error would really be appreciated. I have tried too google it but couldn't find one.

 

Thank you

 

Suthipat

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Hi Suthipat,

     

    I can't see much information from the snapshot. Could you please share the pbix file if possible?

    1. Please click the "Keep Errors" step to see what the errors are.

    Please_help_20_rows_loaded_20_errors

    2. It seems the cause is the date format. What are the formats of your OS and your file. For example, 8 Feb could be 8/2/2018 and 2/8/2018. Please check it out.

     

    Best Regards,

    Dale