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.
v-mpramanik
on:
Retrieve Power BI admin activity events beyond 28 ...
on:
PULL DATAFLOW REFRESH SCHEDULE WITH THE REST API
on:
Improve error message when dataset mixes cloud and...
on:
Deployment pipeline rule for data factory pipeline...