Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, I hope all is well with everyone.
My question is the following, I have these three tables, (item name, UX_salesview, calendar), and I connected the calendar table to the UX_saleview table without problem, but when connecting the Item Name table with UX_saleview it gives an error because it says that it causes ambiguity with the Calendar table.
If anyone could help?
The translation of the yellow rectangle - "Cannot create a direct active relationship between UX_SalesView and ItemNames because that would introduce ambiguity between Calendar and UX_SalesView tables. To make this relationship active, disable or drop one of the relationships between Calendar and UX_SalesView first
Solved! Go to Solution.
I would guess that you have an indirect relationship between calendar and item name via some other tables.
I would guess that you have an indirect relationship between calendar and item name via some other tables.
I went back to doing the relations trying to see if it had any indirect relation with the calendar and it already worked, I don't know if it has to do with what you said, but thanks
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |