Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric certified for FREE! Don't miss your chance! Learn more

Feature to automatically Rename Columns In A Visual Based On Column Name Or Data Dictionary.

Anyone doing database work has seen crazy and nosensical column names. SSF_IDX1m for instance. Or names that came from the days of 8 character limits, etc.

 

But these days column name tend to me more descriptive...FIRST_NAME, INVOIVE_NUMBER ,etc. But these names are still unsuitable for using a column names and other titles in visuals.

 

It would be nice it there was an easy feature to take a column name, once placed in the column list of a visual, and convert it to sentence case, removing "_". So, FIRST_NAME becomes far more friendly First Name.

 

Another approach would be to have Power bi connect to a user provided data dictionary with readable names associated with the database column names. This would allow even SSF_IDX1m to be automatically translated to a human readable, sensible name.

 

Sure, you can do all this manually, but it is a tedious and time consuing task that leaves plenty of room for errors. 

Status: New