Skip to main content
Microsoft Idea

Power BI

Needs Votes

Change names of all or select columns and tables at once

Vote (4) Share
Morten Hannibalsen Olsen's profile image

Morten Hannibalsen Olsen on 09 Oct 2020 07:51:32

It would be nice if we could rename all tables and column with the Replace function and afterward automatically capitalize the first letter of each word.
Eg. often tables and columns in a database are named like this: customer_code.
It would be nice if on all column names the Replace function could be run to replace the underscore with space. Afterward, the CapitalizeEachWord function could be run on all column names.
Then customer_code would become customer code and the Customer Code.
If done on all (or select) tables and columns at once it would be a huge speed boost to development, and would make adhering to best practice as put forth by Chris Webb easier:
https://blog.crossjoin.co.uk/2020/06/28/naming-tables-columns-and-measures-in-power-bi/