Forum Discussion
Relation-Calendar
I have a problem... the tables "Tereni" and "Pozivi" are linked to the "Ponuda Nekretnina" table with the field "NekretninaID," which serves as the key and has unique values in the "Ponuda Nekretnina" table. The "Pozivi" table and the "Tereni" table are connected to the "Kalendar" table, and the calendar functions properly when it involves these two tables.
The issue is that the connection between the "Ponuda Nekretnina" table and the "Kalendar" table doesn't want to work, and I can't see the reason why not. It's giving me an ambiguity error, so I can not use those 3 Tables with the same Calendar slicer,etc...Is there a solution for this?
4 Replies
Thank you very much for suggestion...I will try with that...
Hvala puno 🙂!!!
One question:
considering that this is my main table containing the IDs of properties I have on offer, if I remove all other Many-to-Many relationships, I will surely still have one Many-to-Many relationship connected to the Calendar table. And essentially, I need the Calendar."
Hi / pozdrav obrad02
Possible issue is that in your model there are "unexpected" type of relationships, like for table "Ponuda nekretnina" some tables are connected with many side (asterix) while some are with 1 (1 mark near table). The best practice is to have only one type per table: many or 1. This is only small part of your overall model meaning some other table probaby affect your table "Ponuda Nekretnina" indirectly.
Remodel your model to leverage power bi features
Nadam se da sam ti pomogao 🙂
Do you maybe to have any advice on whether it's possible and how to reverse a relationship?
