Forum Discussion
GeekAlfPro
Helper V
Helper VExcel power query strange behaviour
Hi there, i created a power query script to get the max of a list. it worked fine but a few days later, i copy paste new values, and here is the problem. despistes PQ did the job, i can't h...
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.
edhans
Community Champion
Community ChampionClick 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.
GeekAlfProhi edhans,
thanks for taking time to have a look at my issue.
i've done what you suggested, but the error table is empty...
Strange, isn't it ?