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...
Hi ,
check the source file where it is coming from and what it is defined as a text , decimal or a date, then change the type of it from power queries
Hi!
The column contains years (dates when book are published) and it was whole numbers from the beginning. I changed it to date (yyyy) and it works fine for the rest of the 200000 rows, its just these 77 rows that cause the error.
Can I somehow change the type of just these 77 rows in order to get aroudn the errors?