Forum Discussion

jct999's avatar
jct999
Icon for Advocate II rankAdvocate II
3 years ago

Power Query converts case during import when it is not asked to do so

Hello   I have an Excel file on a Sharepoint that contains sentences, and I import these data in a PBi dashboard. Problem : During import, it converts letters between uppercase and lowercase, wh...
Need Help
ShirinArshadnia's avatar
ShirinArshadnia
Icon for Helper II rankHelper II
3 years ago

hijct999 

are you sure that you donot have a Step to change the lower case or uppercase?

check right Pane "Query settings" in power query editor mode and remove step "Uppercased Text" or go to the advanced editor aand find and remove a row like

    #"Uppercased Text" = Table.TransformColumns(#"Changed Type",{{"Contract ID", Text.Upper, type text}})

 

this might be helpful too:

https://xlncad.com/change-letter-case-using-power-query/