Forum Discussion
Solved
warehouse views performance in semantic model
Good day, I want to know the impact of creating views in a fabric data warehouse when use them in a semantic model. We have the following scenario: We need to make a relationship from a column of a ...
I would suggest creating a composite model of the two columns in both your fact table and your dimension table here. I will then bring this data into your semantic model and create the join on the composite model in the semantic model. This should allow a great performance within the semantic model and not having to worry about the views in the Warehouse
GilbertQ
Super User
Super UserYes that is correct.