
上QQ阅读APP看书,第一时间看更新
Remove automatic type detection steps
- Remove any Changed Type steps that were applied automatically to your queries.
- 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
- 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.