Dealing with errors is an inseparable part of the data-cleaning process, and Power Query provides several functions to handle them. Errors in Power Query can be categorized into two groups: step-level errors and cell-level errors.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

Error-Handling Strategies

  • Omid Motamedisedeh

摘要

Dealing with errors is an inseparable part of the data-cleaning process, and Power Query provides several functions to handle them. Errors in Power Query can be categorized into two groups: step-level errors and cell-level errors.