Forum Discussion
Excel power query strange behaviour
Click on that link that says "there are 30 errors"
You should never ever have errors in your final query GeekAlfPro
You can see what the errors are by going into Power Query for that table and selecting Keep Rows on the home ribbon, then Keep Errors.
Then you have two choices:
- Fix the errors and remove the temporary Keep Errors filter
- If you don't care about the records at all, then remove the Keep Errors filter and do Remove Rows, Remove Errors from the home ribbon.
Frustrating yes, but not strange. I've seen that before. You then have to start digging deeper into the table to see why the error is showing up. It requires doing a lot of filtering and detective work. It may be as simple as you have more columns than you need and one of those unnecessary columns has the error. So remove any columns you don't need (if any) and see if it persists. If it does. you'll just have to dig in unfortunately. No magic bullet.
Yes, i will investigate.
i think it's a side effect.
Actually i use only one column but the file contains hundreds.
i will try again with a copy paste on another sheet, to be sure.
thanks again and have a good day
