cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pistonss Frequent Visitor
Frequent Visitor

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:

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

3 REPLIES 3
pistonss Frequent Visitor
Frequent Visitor

Please help! 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:

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

Community Support Team
Community Support Team

Re: Please help! 20 rows loaded. 20 errors

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

 

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

Re: 20 rows loaded. 20 errors !!

Hi @pistonss,

 

Could you please mark the proper answer as solution?

 

Best Regards!
Dale

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