Forum Discussion
Power Query imports columns in UPPERCASE from Snowflake
Oh sorry, I thought you meant the values and not the headers.
For the column headers please use the Advance Editor
add the following line of code to convert all column names to lowercase:
#"Renamed Columns" = Table.TransformColumnNames(#"Previous Step", Text.Lower)Did I answer your question? Mark my post as a solution!Hi sarahshh ,
MattiaFratello 's solution works for any text transformation so, if by "a mix of lowercase and uppercase" you mean capitalised words with spaces between them, you can use Text.Proper instead of Text.Lower. If your headers are in camel/snake case etc. then yes, unfortunately this won't work for you.
Note that DAX is case-insensitive when it comes to column names in measures etc. so it shouldn't affect any modeling if you choose to just let the column names pass through to the model as-is from source.
Pete
yes, this works to change to lowercase, the only problem is that my headers are a mix of lowercase and uppercase and I can't keep this without renaming them individually.
What I'm trying to do is replacing an old table with a new one (from Snowflake) and I want to keep the exact same headers not to break anything in applied steps or visuals.
Hi sarahshh ,
MattiaFratello 's solution works for any text transformation so, if by "a mix of lowercase and uppercase" you mean capitalised words with spaces between them, you can use Text.Proper instead of Text.Lower. If your headers are in camel/snake case etc. then yes, unfortunately this won't work for you.
Note that DAX is case-insensitive when it comes to column names in measures etc. so it shouldn't affect any modeling if you choose to just let the column names pass through to the model as-is from source.
Pete
yes it's more camel/snake case. At least this won't break my model so thank you for the confirmation!