Forum Discussion

Bakhtawar's avatar
Bakhtawar
Post Patron
6 years ago

Northwind databases relationship

Hi all

i am try to create a star schema of northwind database.. problem is supplier table is unable to connect with order_fact _table where there is already supplier ID in fact table and in supplier table.. initally there is no Supplier ID in order_Fact_table so i will get this from product table.. 

 

kidly check file and let me know 

this is the diagram 

 

 

file link 

dropbox.com/s/3eqqu88bewlvimg/test_fle.pbix?dl=0 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi Bakhtawar 

    Just delete the existing relationship between suppliers_dim and products_dim and add the new relationship between suppliers and your fact table.
    powerbi doesn't always create the right relations between tables.

    • Bakhtawar's avatar
      Bakhtawar
      Post Patron
      6 years ago

      yes i am trying this already but the point is SupplierID is come from Products table so unable to remove SupplierID from products table.. so because of this products table create relationship with Supplier Anonymous