Northwind databases relationship

[Bakhtawar]

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 

[Anonymous]

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]

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