Data fetch issue with Left join in PBI

[Anonymous]

Hi Team,
  Below is the relationship that i have in PowerBI Data model.
 
Table 1-
  - Invoiced Sales
  - CustomerID

Table 2
  - CustomerID

Table 3
  - TerritoryID

Table 4 - (Bridge table)
  - CustomerID
  - TerritoryID

Table-1 is linked with Table-2 based on CustomerID

Now issue  is i'm facing -- if we do not have any records in Table 4 (bridge table) - No data is being displayed from Table-1 (inner join with Table2)
but I need to show the records from Table-1 (basically Left join) irrespective of CusomerID present in Bridge Table.

Need your help please.

Regards,

[v-diye-msft]

Hi @Anonymous 

Please kindly help mark the above answer as solution if it helps, others will benifit from it. thansks! 

[d_gosbell · Accepted solution]

The simplest fix here is probably to add any missing customer ids into your bridge table and just leave the Territory ID blank