Trevor White on 21 Dec 2023 13:36:29
Very often you refresh a dashboard and it says there are errors, ok so you accept the suggestion to create an error view in Power Query, but now you have to find the column with the error in it, fix the source or apply transformations in the table (not the error table), this takes a lot of time.
It would be really helpful if under view Microsoft would implement "Go to error" in which Power Query would look through the entire data set and report back "No Errors found" or jump to the field and row which contains the error so you can examine it further.
I realise the error might not be in the first 1000 rows so it's find to have a dialog showing progress or how many rows it's checked so far with the option to cancel it, or ask the user how many rows it should scan.