- 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 ...