How to capitalize the each word in column names pulled from the Oracle source

[ArulselvanD07]

I have Oracle DB as the source and I have imported close to 10 tables and the total number of columns imported are around 100. Oracle uses the format "COLUMN_NAME" for it's columns, I want to change it to something more meaningful, say "Column Name". I searched for options to do it in Power BI, but couldn't find that option.

Is there a way we can change the Column names to replace the underscore with space and then Capitalize each word instead of manually renaming all the columns one by one? Please note that I have used the import mode with query override. Thanks in advance for your suggestions.

[ImkeF · Accepted solution]

Hi @ArulselvanD07,

this query contains the necessary steps:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUTJSio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [COLumn_FJKD1 = _t, Column_ASDLFKJA = _t]),
    OldColNames = Table.ColumnNames(Source),
    ReplaceUnderscore = List.Transform(OldColNames, each Text.Replace(_, "_", " ")),
    NewColNames = List.Transform(ReplaceUnderscore, each Text.Proper(_)),
    Rename = Table.RenameColumns(Source,List.Zip({Table.ColumnNames(Source), NewColNames}))
in
    Rename

[francescakdonov]

Hi ImkeF - how can you pull from multiple source points?