Power BI relationships

Question

I created following data set as illustrated below:

You can see four level's.

• level 4: the records that tie everthing together, in this case : reservations. Or more precisely: object-reservations, since there is a record per object-reservation (ie: if a reservation is for 3 objects, then there is a reservation record for each of those objects, with the same reservation ID, thanks to a ExpandColumn in the power query)
• level 3: the objects being reserved, of different types. A reservations can have serveral objects of serveral types reserved. These level 3 objects are the 'main' objects. So I have the 'main' relationsships set up ok. There are business rules for that, implemented in the sw this data is taken from.

So far so good

• level2 : certain types of objects (the 2 leftmost of level 3) belong to an 'organisational' level 2. In fact, that level 2 can also be allocated directly to a reservation, in combination with these level 3 object types. The software from which this is extracted has business rules to assure consistence between those links. But I would lke to have at least the course_studenset (level 3) linked to the course (level 2). Also the link between course and resesvation is there, but I can live without the link in the model. The tables have all the info for those links but Power BI refuse to create them due to the risk of inconsistence if I understand the error message well.

• level 1: similar to the level 2: course (level 2) en studentset (level 3) belong to a curriculumlvl3 (level1). And the curriculumlvl3 can even be on of the objects liked to a reservation directly. Again, consistency is assured by the business sw rules. And again Power BI refuse to set a relationship between both curriculumlvl3 and studentset, as well ascurriculumlvl3 and reservation. Again, that last relationshop is optional if the first one can be set up since studentset is more ganular than curriculumlvl3, and there shold be no reservations with a curriculumlvl3 object and no object from the hierarhy below.

All objects that link to eg. curriculumlvl3 have fields holding both the ID and the 'call name' of that level above. So I could imagine using that field to make a report on curriculumlvl3 level, rather than exploiting the relationship. Same for course and subtypes.

Since this is my first Power BI, I'm struglling to see the 'best practice' for this situation. From a puristic point of view, I'd prefer a 'perfect model'. But I'm a pragmatic guy :)

Question is:

• can I and should I model coure_studenset<->course and studentset<->curriculumlvl3 ? Or am I on the wrong track? And how?
• can I and should I model reservation<->curriculumlvl3 and reservation<->course ?

Thanks

C.