Service Desk Reports Using Microsoft Power BI
I'm trying to create some dynamic Service Desk reports using Power BI but I'm getting stuck when it comes to relating Owner ID and Submitter ID back to an actual name. IN the HD_TICKET table I have almost all of the information I need to create the graphs I want, however, I am only presented with an "ID" field with numbers rather than actual names of employees.
Any idea how to relate these tables or otherwise get the numbers to generate actual names for my reports? Thanks in advance!