Forum Discussion
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...
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.
Hello lbendlin,
Thank you very much for your help.
Unfortunatly, my problem persists, I cannot put the Item's Code in the table on Page 1 without it breaking and giving a "Can't determine relationships between fields" error.
Do you have any advice on how I can get this working please?
Thanks again for your help,
Beefheart
Did you make changes to the data model? Can you please post the updated pbix file?