Forum Discussion
Error when refreshing
Hi, When I do a resfresh in desktop I get an error in 78 rows and I don't really understand why. First I thought its because source_published are empty/missing data for these books but w have many m...
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 ,
I like the sound of option # 2 🙂 Care to help me how a power query like that would look like?