Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Yrstruly2021
Helper V
Helper V

Joining Parent/Child tables, foreign keys.

Please assist in creating the appropriate relationship between tables: PI_ServiceRequest and PI_ServiceRequestAssociatedFBO.

On what columns do i join ?

https://drive.google.com/file/d/1iI5CmvZMKetaVV7Ugwc9pBXqQqFIuAxu/view?usp=sharing 

3 REPLIES 3
serpiva64
Super User
Super User

Hi, in your example there is not a table called PI_ServiceRequestAssociatedFBO

 

Yrstruly2021
Helper V
Helper V

Between Service_Request_Associate and Service Request.

tackytechtom
Super User
Super User

Hi @Yrstruly2021 ,

 

In your file, I can only see these three tables:

tomfox_0-1644347902500.png

 

Seems like PI_ServiceRequestAssociatedFBO is missing?

 

/Tom

https://www.tackytech.blog

https://www.instagram.com/tackytechtom



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.