Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to make the highlighted relationship active, I figured I would be able to, since everything is flowing in one direction. Any ideas why that is not the case?
I am trying to be able to show orders by market by customer by driver.
Error message is correct. I can see 2 paths from Market to DimOrder.
---
You can
1. Alter the model by having 1 or more inactive relationships and activating them in the appropriate measure used
or
2. Possibly use a copy of Market table and break the link that's causing the error.
--
You might need to rethink the model anyway. I can see many-to-many relationships and 'bridge' tables that probably aren't needed.
I don't think there are any "many to many" relationships. However, I agree the Market section of the modelling probably needs an overhaul, which is the long-term goal, and my short-term fix seems to not be the correct approach.
Thank you!
"to make the highlighted relationship active" - Can't tell which relationship from the picture. Can you clarify?
Post the error message too.
- This is the error message that means you have 2 paths to get to the same table, so that'll be the issue
The highlighted relationship is the one to many between Market and Driver Market Mapping
Error Message:
Also if possible, how could this be corrected to filter DimOrder correctly by Market through both DimDriver and DimCustomer?
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |