Skip to main content
Microsoft Idea

Power BI

Needs Votes

Automatically Capitalize Columns Using Lowercase with Underscore Convention

Vote (2) Share
Will Ayd's profile image

Will Ayd on 06 Aug 2020 16:29:22

Naming identifiers using lowercase letters and underscores as word boundaries is a common convention particularly in databases like Postgres, where unquoted identifiers are automatically converted to lowercase anyway.

When ingesting identifiers in this fashion, it would be nice for Power BI to have a built in way to capitalize and replace the underscores with spaces. Other tools like Tableau perform this natively.

This is possible today with custom code as shown here:

https://community.powerbi.com/t5/Desktop/How-to-capitalize-the-each-word-in-column-names-pulled-from-the/td-p/420131

But would be nice to not have to replicate that code across every table being pulled into a dataset