Error on refresh

[stribor45]

When I run the refresh in power query one of my queries reports one error. The name and date of that show as a new folder "Query Errors 11/6/2023". Inside that folder, there is query Errors in "my query name" and i can see one row in that error query. How can I get this row back inside my "real query" or how to fix this error? This row also has a new column called row number. How do I fix this?

Thanks

[amitchandak · Accepted solution]

@stribor45 , please share the exact error along and what operation you are doing.

Replace my error if trying to replace text data as whole number

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs