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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
HeirsPowerBi
Helper I
Helper I

Model is Enforcing Inner Join

Hello Guys

I have a data model like this

HeirsPowerBi_0-1657030698937.png

 

 

But for some reason when i bring in columns from policies and endorsements to a table visual it appears like an inner join instead of showing me all the policies it only shows the ones that have endorsements......then when i add a column from installments to it i get the error that it cannot determine relationhip between two fields.


 

I cannot figure out why this is because i want to see all policies....Empty values for endorsement where there is none and same for installment, Please help

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@HeirsPowerBi , You can not have not-summarized column from two many side tables

 

so column from endorsements  or installments need to have some aggregation

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@HeirsPowerBi , You can not have not-summarized column from two many side tables

 

so column from endorsements  or installments need to have some aggregation

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

I may have been too quick to mark as solution.

 

So i have removed the column from installments and what i get is still an Inner Join of policies and endorsements, instead of a Left Join

Any ideas

Helpful resources

Announcements
October NL Carousel

Fabric Community Update - October 2024

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