The original statement ("select from @{pipeline().parameters.Schema}.@{item().TableName}") does not always returns a result set with the columns in the specific order that the json model file is created.
So, we need to use the exact same column order in our select statement here as the one that is used to create the .cdm.json model file.
The original statement ("select from @{pipeline().parameters.Schema}.@{item().TableName}") does not always returns a result set with the columns in the specific order that the json model file is created. So, we need to use the exact same column order in our select statement here as the one that is used to create the .cdm.json model file.