Forum Discussion

Jgordon20's avatar
Jgordon20
Regular Visitor
4 years ago
Solved

Dataflow adding a rename step for long column names

We're having an issue with our dataflow where upon saving and closing, it will add a column rename step. If we remove the step, it will be re-added. The rename step appears to be truncating and colum...
dataflow
Need Help
  • edhans's avatar
    edhans
    4 years ago

    MS just improved the dataflow schema validation, and one of the things it does is fix issues, and apparently column names over 80 chars is an issue downstream somewhere. 

    I will try to find out more, but honestly, super long column names are bad practice. I cannot imagine writing DAX dealing with column names like that.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Jgordon20 ,

This seems to be an limitation. 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
4 years ago

That is a limit if the name of the query Anonymous , not field names. If it applies to field names than that documentation needs to be updated. Field names though do not have such a limitation in other products like Power BI, so either this is a new limit for other reasons (downstream products in dev for example) or it is a bug.