Forum Discussion

Frequent Visitor

2 years ago

PBI perform inner or outer join

Hello everyone, I would like to aks you about data modeling in Power BI. If I choose my tables set like star schema at model I dont understand how to set inner join or outer join. If I will be speci...

Tips and Tricks

Super User

2 years ago

Data model joins are generally behaving like left outer joins, and that is perfectly fine for the vast majority of situations.

see attached

data model.pbix23 KB

Anonymous
Not applicable
1 year ago
If I give relationship between fact and dim as many to 1 in modelling, then what kind of join it is. Is it left join or inner join?
- lbendlin
  Super User
  1 year ago
  those are slightly different concepts. Read about AutoExists.
  - Anonymous
    Not applicable
    1 year ago
    I read about autoexists. But In my model I do have fact and dim.
    fact table contains
    sales product_key
    20 1
    30 2
    40 3
    
    in my product table I do have only A,B products.
    Product_key Product
    1 A
    2 B
    
    then when I consider my sales from fact and product_ID from Product table then I am seeing as below
    Sales Product
    20 A
    30 B
    40
    
    here I am seeing blanks in Product. Which is not expected from my user. They are expecting only inner join. How to achieve this.
    
    I don't want any inner join in my query editor.
    How to achieve this.