Forum Discussion
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
- leonardmurphy
Skilled Sharer
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.