20 rows loaded. 20 errors !!

[pistonss]

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 brought me to this:

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]

Hi @pistonss,

Could you please mark the proper answer as solution?

Best Regards!
Dale

[pistonss]

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 brought me to this:

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]

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.

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