Forum Discussion

Dayna's avatar
Dayna
Icon for Helper V rankHelper V
7 years ago
Solved

Cyclic relationship on table structure

Hi All,   I have two database tables: Server and Test Log   In the server table, I store some basic information about the server, for example, the date it was issued, the name, etc...   In the...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi Dayna,

     

    Sorry for late, I have reproduced your issue like below. For example, if you create a slicer based on one column in MasterCalendar table and select a value to filter DR TestingLog. There're two kinds of filter route, one is MasterCalendar-> DR TestingLog, another is MasterCalendar-> DR Server-> DR TestingLog. So there may be two different filter results in DR TestingLog which may cause ambiguity. 

      

     

    Regards,

    Jimmy Tao

     

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Dayna,

 

Change the direction between 'MasterCalendar' and 'DR TestingLog', between 'DR Server' and 'DR TestingLog' from bidirection to single direction.

 

Regards,

Jimmy Tao

Dayna's avatar
Dayna
Icon for Helper V rankHelper V
7 years ago

Hi Jimmy,

 

Tried it - but still unable to make the relationship active. I've included a screenshot of the updated ERD: