Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowFabric Data Days Monthly is back. Join us on March 26th for two expert-led sessions on 1) Getting Started with Fabric IQ and 2) Mapping & Spacial Analytics in Fabric. Register now
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.