How to Look up / match database field names with descriptions

[44Bailey]

Hello,

I'd like to use an SQL database (from a system) as my source, however when I connect to the databse, all of the fields come through in to PBi named as per the database field name and thereofre any options for example in a dropdown box will appear as their code as opposed to the Description (APPL / Apple).  In the database there are additional tables with the field Descriptions (how the fields appear on the front end to the user).

My question is how can I link the relevant database field names with their corresponding Descriptions.  Can this be done as a lookup in PBi or similar please?

Thank you in advance and any advice greatly appreciated.

[v-yalanwu-msft]

Hi, @44Bailey ;

If i understand correct, i think you could use table visual, and select don't summarize.

Or use merge function in power query.

https://community.powerbi.com/t5/Desktop/Union-all-with-multiple-table-joins/td-p/348474

https://community.powerbi.com/t5/Community-Blog/Combine-multiple-tables-with-UNION-UNION-ALL-in-SQL-...

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.