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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gavin007
Helper V
Helper V

add relationship column to existing source

I have a existing salesforce tables in my data model. I am having difficulty to set up proper relationships between sales rep, account, contact and task tables as the ambigirous relationship 

 

Sales rep->Account->Contact->task

Sales rep->account->Task

 

The workaround is to break one of the link and replaces with a related column in the task tables. illustrate like below

Sales rep->Account->Contact (broken link),  Task has contact column

Sales rep->account->Task

 

My question is, without creating a new task table, how to enable the relationship column in existing task table? I just don't want to recreate 6 table and link up visual again, which could be two days works.

 

If in a new get source window, i click on the box.

Capture.PNG

Capture1.PNG

 

 The table i import has the relationship table.

Capture2.PNG

 

So my question is how to enable them in an EXISTING tables, or any suggestion i can use DAX to create a new column?

 

 

3 REPLIES 3
amitchandak
Super User
Super User

@gavin007 , I think first you need to explode those tables and make a table with only data. 

 

If you can let us table structure, we can suggest joins

I have created a new file and here is the screen shot. 

Capture.PNGCapture1.PNG

 

What i want to achieve is two things.

1. Set up relationship link with strong relationship requirement.

-sales rep<-> account,

-account->opportunity,

-account->contact,

-sales->lead

 

Weak relationship will acheived by relationship column like

-Task table has opportunity name, lead name, account name, and sales rep name

-Event is similar set up 

 

2. if the above or any other suggested struture work, can it retro-fit to exisiting data model

 

Any update on this?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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