Forum Discussion

Pappy54's avatar
Pappy54
Regular Visitor
2 years ago

Cannot Create Relationship in Data Model that joins more than one column

I am creating a data model in MS Fabric but need to be able to create a relationship that joins data from more than one field in the two tables.   For example, Table A has two fields named DataAreaID...
data warehouse
Fundamentals
one lake
power bi
Pappy54's avatar
Pappy54
Regular Visitor
2 years ago

Creating a view is exactly what I did.  I concatenated the dataareaid field with the itemid, naming it IDX_DataAreaIdItemId.  I was trying to avoid this approach but it appears that I will have no choice.  I know that Fabric is a work in progress but for any business that has a multi-company instance of D365 F&O, including the dataareaid in your joins is a must.  Until there is multi-column functionality with regard to table relations within the data model, views will need to be created for all of our fact tables and many dimension tables, such as the item table indicated above.  Thank you very much for your quick response.

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi Pappy54 


We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .


Thanks.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    2 years ago

    Hi Pappy54 

     

    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.