Forum Discussion

slgal's avatar
slgal
New Member
10 years ago

Can I use several active link to same table?

Hello All, I have a trouble with building report using Power BI Desktop. Here is my db scheme:   Persons PK_PersonId | FullName   Orders PK_OrderId | FK_CustomerId | FK_CashierId   Where FK_...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi slgal,

 

In your scenario, it seems that two tables Persons and Orders contain a common filed. If that is a case, you can get all those fields from two tables use SQL joins if you are using SQL database as data source.

 

If the way doesn’t meet your requirement, please share those tables relationship and contained sample data. Also please provide a screenshot about your expected data. 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

Anonymous's avatar
Anonymous
Not applicable
10 years ago

slgal

i think Person is like a Role Playing Dimension here

i think Just Creating the Relationship is fine and One can be active other can be just a relation

so, if you query that will provide the output what you are looking for

 

 

Or

Create a New table (Replicate Person) as below
Customer = 'Persons' and rename columns and create relationship :-)

 

 

thanks