Forum Discussion
Three-way relationship between data sources
I'm trying to connect Order Product to Order while also maintaining the date relationship. 'Order' on Order is the key to salesorderid on Order Product but whenever I try to add a connection, it says it would introduce ambiguity between the tables. Is there any way to effectively go about this or is it not realistic?
CalebG , if you want to use the order as fact, then it should not join it with the Order product.
Options are, At source or in power query merge required column need in Order product from order. Kepp both tables
Or create two copies of order, one as fact and another as dimension
2 Replies
- amitchandak
Super User
CalebG , if you want to use the order as fact, then it should not join it with the Order product.
Options are, At source or in power query merge required column need in Order product from order. Kepp both tables
Or create two copies of order, one as fact and another as dimension
