Forum Discussion
Expression.Error: The index cannot be negative
Hi All, Maybe you can help me with this error. I was running Power Query a lot of times and did not have this error. Now it showed up and I am not able to find where is the issue with it. ...
Please investigate both tables before joining. Error may appear on this step, but it doesn't mean that this is caused by this step.
JestedJoin reads all the data to perform the operation. Therefore, it will load all the rows, where you might have errors which don't appear in Previews (where you deal with limitted data). Try go to both tables from before join, and use Table.SelectRowsWithErrors function to find the step which is causing your error.