How to Rename all column names through Direct query in Power BI

Question

Hello,&nbsp;I have 15 tables in my datamodel which are connected through direct query to postgres database in Power BI. I want to rename all columns in those 15 tables in bulk not through manually one by one. I want to replace '_' underscore with space. For example,Old Column Name: customer_account_name&nbsp; , New Column Name: Customer Account NameIs there any solution then please help.Below m-query i am using:NamesBuffered = List.Buffer( Table.ColumnNames( Source ) ),NewNames = List.ReplaceValue( NamesBuffered, " ", "_", Replacer.ReplaceText ),Result = Table.RenameColumns( Source,List.Zip( { NamesBuffered, NewNames } ) )&nbsp;&nbsp;&nbsp;&nbsp;Thanks in Advance.

anonymous · Accepted Answer

Hi&nbsp;NehaliSurve&nbsp;,
&nbsp;
When the connection mode is DirectQuery mode, you can't rename the column headers in Power Query.
This is because DirectQuery mode does not import data into Power BI, so the column headers are defined by the data source. Therefore, you can't rename the column headers in Power Query.
This is also indicated in the screenshot you provided.

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

How to Rename all column names through Direct query in Power BI

1 Reply

Related content

Renaming columns and adding columns

Conditionally rename columns

Views - Renaming Columns

Rename columns from list

Renaming Columns by Column Number