Forum Discussion
Error when expanding SharePoint lookup field in Power Query Editor
Hi biterbit
On the column of Records with errors, select the column then from the Home tab of the Ribbon, click on Keep Rows then Keep Errors.
This should give you a column containing any errors in it. You can then examine the errors by clicking into the column beside the word Error to see what is wrong.
If you have lots of errors there are other things you can do create columns showing the error message and details. This involves creating columsn using try otherwise to extract the Error Record information. Post back here if you need me to write this for you.
FYI Dealing with errors | Microsoft Docs
Regards
PHil
Hi biterbit
On the column of Records with errors, select the column then from the Home tab of the Ribbon, click on Keep Rows then Keep Errors.
This should give you a column containing any errors in it. You can then examine the errors by clicking into the column beside the word Error to see what is wrong.
If you have lots of errors there are other things you can do create columns showing the error message and details. This involves creating columsn using try otherwise to extract the Error Record information. Post back here if you need me to write this for you.
FYI Dealing with errors | Microsoft Docs
Regards
PHil