Forum Discussion
Helper IIIPower BI shows relationship exist even when it doesn't
Hi,
I'm having this weird issue where when I try to create relationship between two tables power bi shows that there is already active relationship between tables but in relationship table or tab I do not see any such relationship and also when i pull that dimension data doesn't show as per attributes instead it shows same value for all attributes.
Any idea what could be going on here?
thanks,
Dilkush
Have a look at screenshots present on this drive
https://drive.google.com/folderview?id=0BwfO8bhz8kBfUFNVX2V5SS1DU1E&usp=sharing
Now it shows that there is an indirect relationship between fact and interim table but when I pull interim and one of the fact it does not work.
Thanks,
Dilkush
4 Replies
- Greg_Deckler
Community Champion
Can you post some screen shots of what you are seeing, I can't visualize what you are seeing from your description.
dilkushpatelHave a look at screenshots present on this drive
https://drive.google.com/folderview?id=0BwfO8bhz8kBfUFNVX2V5SS1DU1E&usp=sharing
Now it shows that there is an indirect relationship between fact and interim table but when I pull interim and one of the fact it does not work.
Thanks,
Dilkush
- WillT
Community Admin
As you've found, even indirect relationships count when we are creating a new one. Check the directionality of your relationships - they might not need to be bidirectional, and that might make the flow of relationships work better for your model.
