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...
ondrej-cdc
2 years agoFrequent Visitor
Ok, thank you very much. I just thought, that there will be some approach above star schema, not to create join at Power Query level and send to report flat table. I thought this is a basic thing, perform inner or outer join.. Guess there will be some reasons, like Ibendlin wrote that it is usual practise show innactive members and so.
If anyone find another approaches I will be thankful.
Thank you very much all of you,
Best regards Ondrej
lbendlin
2 years agoSuper User
Your data model needs to follow your business question. If your business question changes then adjust your model accordingly.