Relationship issue

[CarlsBerg999]

Hi,

Im trying create a relationship between "Date" and "Post Time". I dragged the Date --> Post Time and it keeps giving me an error that a relationship already exists. Why is this? Clearly there is no relationship and ive tried restarting the file etc. 

[Anonymous]

Hi @CarlsBerg999 

What kind of data source did you use in power bi?

This is not an error, it is just a warning, telling you that there is already a relationship between two columns.

Maybe there were some reason cause relationship didn't show.

Please open "Manage relatioship" in model view, and check whether there is already a relationship. Or you can build a visual with columns from two tables and check whether the value will be filtered by relationship.

For reference: Create and manage relationships in Power BI Desktop

Please download the latest desktop version and try again. 

Download: https://www.microsoft.com/en-us/download/details.aspx?id=58494

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@CarlsBerg999 , Close power bi open again and check. I faced this with Jun 2021 a few times, when the relationship was created and was not visible.

or

Can you share a sample pbix after removing sensitive data.

[CarlsBerg999]

This worked after a few times. Seems to be a bug that occurs randomly on files with a lot of relationships. Not quite sure if extra RAM etc. helps with this issue, because other programs were working on an "ok speed" even though the pbix file was pretty big.