Power BI
Needs VotesAutomatically Capitalize Columns Using Lowercase with Underscore Convention
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