Forum Discussion
Column name in power query
Hi,
I've a question - I upload data from excel to power bi desktop & while transforming data - power query doesn't see the whole name of column. In excel file (input file) column name is as a wrapped text - this maybe the reason?
Thank you!
Kasia
Hi kasiak - I agree this is unusual. Power Query will normally identify all the Text in the Cell. It is possible, the header row contains a Carriage Return or Line Feed character. To test if this is the case, try import the headings as Range without heading (i.e. promote them later).
To remove the above I can use the following Replace function:
Table.ReplaceValue(Source,"#(lf)","",Replacer.ReplaceText,{"Column2"})
2 Replies
Hi kasiak - I agree this is unusual. Power Query will normally identify all the Text in the Cell. It is possible, the header row contains a Carriage Return or Line Feed character. To test if this is the case, try import the headings as Range without heading (i.e. promote them later).
To remove the above I can use the following Replace function:
Table.ReplaceValue(Source,"#(lf)","",Replacer.ReplaceText,{"Column2"})Anonymous thank you for your help!
