Remove automatic type detection steps

  1. Remove any Changed Type steps that were applied automatically to your queries.
  2. This step will be applied to unstructured sources such as data tables from Excel workbooks and can be found immediately following selection of the source item.
Figure 143: Automatic Data Type Selection Step
  1. View the expression of the step to observe that every column was referenced by its specific column name.
Figure 144: M Expression generated by automatic data type detection
  • If even one of the source columns is removed or revised in the future, the query will fail due to the dependency on all original source columns.
上一章目录下一章