Forum Discussion
How to FIND the source of 'DataFormat.Error: Invalid cell value '#NAME?'.'
Hi Netrelemo
You can apply those steps :1. From the view tab check on the option "Column quality"
2. If you have more than 1000 rows, you can test all of them if you change the default option:
Just click on the bottom left inscription and choose "column profiling based on all data set"
3. On hovering the mouse cursor on the place of statistics of quality m select the option of keep errors:
In this way you will stay with your problematic rows and their details :
You can also refer to the Microsoft documentation about the issue :
https://learn.microsoft.com/en-us/power-query/dealing-with-errorsfrom the part :
Handling errors at the cell level
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Netrelemo
They appear on some steps, you just need to go over all the steps that are recorded and wait until the step updates itself (a few seconds).
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
I'm experiencing the same issue. While that column quality tip is useful... it doesn't locate the error. Halfway through my applied steps is where the error must be but it goes from showing the 3 % options at the top row (just like in the screenshot) to the next step (where error(s) must be) each of the cells that had the 3 % options for column quality now show "An unexpected error occurred". Also, no, it's not about waiting for anything to load to locate the error(s). Each of those cells spins for a bit before showing that unexpected error message in each of the cells. That is how it looks for every step following that first error step too.