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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Afiz
Frequent Visitor

Cant create relations between two tables

Hello!

 

I have a Task table (from server)   and  Lead (From salesforce), both contain column LeadID.

 

In the  Lead table, (Lead.LeadID) is  unique and  not in Task (Task.LeadID), so i thought i could use a many to one relationship(or vice versa).

Well, that did not work. So, for every unique entry in  Lead  (as in Lead.LeadID), multiple entries occur in Task.LeadID and each entry has a unique Id (as in Task.Id). 

 

I do not know what the problem is exactly, perhaps someone could help me out with this. Thanks in advance

0 REPLIES 0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors