Power BI shows relationship exist even when it doesn't

[dilkushpatel]

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

[Greg_Deckler]

Can you post some screen shots of what you are seeing, I can't visualize what you are seeing from your description.

[dilkushpatel · Accepted solution]

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

[WillT]

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.

[sshweky]

Can yuou briefly explain what yuou mean by "directionality of relationship"? Thanks!