Forum Discussion

NehaliSurve's avatar
NehaliSurve
Regular Visitor
3 years ago
Solved

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

Hello,   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...
Data Protection
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi NehaliSurve ,

     

    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.

                                                                                                                                                             

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi NehaliSurve ,

 

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.

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.