Forum Discussion

EasyNet's avatar
EasyNet
Frequent Visitor
9 years ago

Relationships in Direct Query Mode

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.

Need Help

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee
    9 years ago

    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,