Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Dataflows consistently add Table.TransformColumnTypes and Table.ReplaceErrorValues steps

When saving, Premium Dataflows almost consistently add two steps to my logic - Table.TransformColumnTypes and Table.ReplaceErrorValues. These appear without my request and cover multiple columns in t...
Dataflow
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

     

    It is by design, you may contact the support or submit an idea.

    https://ideas.powerbi.com/ideas/ .

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
3 years ago

For those curious, any column that does not have a non-Variant data type seems to be automatically set to a text type if you save and leave the designer. The two steps are added for that purpose - to set any Variants to text and to replace errors.