Forum Discussion
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...
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.
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
