Forum Discussion
Error when refreshing
Click in the Error 'cell' (but not on the Error) and the message below will show you what the error is.
Thank you for the reply.
This is the error message:
I change the column from whole number to date (yyyy) and the rest of the 200000 rows works fine, even around 3000 rows where source_publiched are empty genereates no error. Its just these 77 rows that do. Any idea what I can do to fix it?
Dear , check the nature of the dates maybe its not a date for these rows , if you can share some sample to figure it out .
Regards ,I would love to share some example but not sure how 🙂 Before I do the refresh, these cells are simply empty.
hi ,
so you know the error from where , you can do as follow for it :
Option 1 - in power queries try to remove the blanks ( in this case the rows will be deleted , data loss may occur )
Option 2 : replace the blank values with a date ( this will solve the issue and the rows will be kept as is )
Please accept as a solution if this works with you .
Regards ,
