Forum Discussion

Beefheart's avatar
Beefheart
Helper I
3 years ago
Solved

Relationship Issues

Hello Everyone, I think I have a relationship problem. I’ve attached a pbix and a screenshot of the relationships is below.     Basically, we have customers that own assets and those asset...
Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    There is no relationship between customers and components. Therefore you cannot show these in the same visual.

    Same issue between items and assets.

     

    You could work around this by denormalizing some of the tables,  but it may also be a case where the question you are trying to answer with the report needs to be reconsidered.

lbendlin's avatar
lbendlin
Super User
3 years ago

Looks like you linked to the virtual machine image instead of the pbix file.  Might want to correct that.

Beefheart's avatar
Beefheart
Helper I
3 years ago

Hi lbenflin,

 

I've changed the link to a dropbox account that shares the .pbix file.

 

Thanks for your help and sorry I'm taking up your time.

 

Best regards,

 

Beefheart.

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    There is no relationship between customers and components. Therefore you cannot show these in the same visual.

    Same issue between items and assets.

     

    You could work around this by denormalizing some of the tables,  but it may also be a case where the question you are trying to answer with the report needs to be reconsidered.