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.
... View more