Power Query Error Handling Part 2 - How to Deal with Power Query Errors

Learn how to deal with Power Query errors that display error values in the cell. These are usually data type errors that do not prevent the data loading into the query; instead those cells will be loaded as blank. The Queries and Connections Pane shows the error and indicates the number of lines with errors. While there could be multiple lines with errors, you may not need to fix each row individually. Changing one step may be sufficient to fix all the errors at the same time. Learn what causes these errors and how to fix them in this video.

Links Mentioned in this Video:
1️⃣To learn how to deal with Power Query errors that result in the column of the table wasn't found errors and download did not complete errors, please check out Part 1 of this video "Power Query Error Handling - How to Deal with Power Query Errors:"

✅ For more Power Query videos please use the links below:

[eslamfahmy]

Thank you, but I need to know why you used the index num ?

[eslamfahmy]

Thanks, can u share with us all join kind in one video