Forum Discussion

kenzzzo82's avatar
kenzzzo82
Regular Visitor
10 years ago
Solved

Creating a custom column that pulls in data from a related Database table`

I am new with PowerBI but it looks like a great tool to run some reporting we need on an incident tracking system. I think what I am trying to do seems basic, so sorry for the basic question :) 

 

I want to pull in a customer's name based on a related guid between two tables. 

 

So for example there is a table called incident, and that table has most the data I want to report on, but i nstead of the Customer's name it has a field CustomerGuid which is a foregin key that relates to the Customer table which contains CustomerGuid with the Customer name. 

 

There is also a relationship like this between Incident and Client table which will pull in the Client's firm name ideally. How would I go about doing this?

  • You can bring in each table as-is into Power BI Desktop and create a relationship between them in Power BI (indeed, Power BI may even auto-detect the relationship).

     

    Then you can hide the GUID so people don't see that in the field list and use Customer Name / Cient Name from their respective lookup tables in reports, etc.

1 Reply

  • You can bring in each table as-is into Power BI Desktop and create a relationship between them in Power BI (indeed, Power BI may even auto-detect the relationship).

     

    Then you can hide the GUID so people don't see that in the field list and use Customer Name / Cient Name from their respective lookup tables in reports, etc.