Power Query imports columns in UPPERCASE from Snowflake

[sarahshh]

Hello,
I’m importing data from Snowflake in Power Query (PowerBI) via a SQL query and I get all columns imported as UPPERCASE although my query specified a mix of lowercase and uppercase (ex: SELECT “My_Column” FROM my_table). How to change this without having to rename them all individually in Power Query?

Thanks!

[MattiaFratello · Accepted solution]

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!

[MattiaFratello]

Hi @sarahshh, have you tried to use Transform -> Format?

Did I answer your question? Mark my post as a solution!

[sarahshh]

no it doesn't work, it converts the values inside the column, not the names of the columns

[MattiaFratello · Accepted solution]

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!

[sarahshh]

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.

[BA_Pete · Accepted 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

[sarahshh]

yes it's more camel/snake case. At least this won't break my model so thank you for the confirmation!

[BA_Pete]

Hi @sarahshh ,

I don't think you can.

IIRC, Impala does exactly the same, it's just the nature of the connector.

Pete