Relationships in Direct Query Mode

[EasyNet]

best regards, I would be very grateful if someone could help me with this case, I have the tables to relate, a representation of sales by the seller and the other budgets, the table of budgets has the figures divided by the type of product. When I am going to establish the relationship does not allow it to me because one of the tables does not have unique values, this is correct since each data is different in both sales and presupases. How can I establish this relationship considering that I am working in DirectQuery mode and not in Import mode? Thank you so much.

[v-sihou-msft]

@EasyNet

In your scenario, it seems you have Sales and Budgets tables which are fact tables. You should have other dimension tables like DimSeller, DimProduct, etc, and build the relationships to those fact tables based on the key column with unique values in dimension tables. It can became a snowflake/star schema. You can refer to AdventureWorksDW sample database.

Regards,