Forum Discussion
ondrej-cdc
2 years agoFrequent Visitor
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...
lbendlin
Super User
1 year agothose are slightly different concepts. Read about AutoExists.
Anonymous
1 year agoNot applicable
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.