cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ajprosser Frequent Visitor
Frequent Visitor

Relationships not working even though they have been created

I have created a relationship between a table which has a unique set of asset codes (A) with two other tables on asset code (B and C).

 

If I put a field from B into a visualisation table it works but as soon as I add a field C I get a relationship error. Or the other way around.

 

I have attached two screenshots - one of the error message and one of the relationships I've set up.

 

The formating for asset code in all three tables is Text.

 

I've run out of ideas and cannot seem to find a similar issue in the forums.

 

powerbi2.jpgpowerbi1.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Relationships not working even though they have been created

Hi @ajprosser,

 

I'm afraid we can't use it like that. It's quite clear in the example below. What's the result that you were going to achieve?

Relationships_not_working_even_though_they_have_been_created

Now, we create a table visual.

asset code    asset classification       product type

computer     electricl equipment      ??? (type 1? type 2? type 3? type 4?)

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Relationships not working even though they have been created

Hi @ajprosser,

 

I'm afraid we can't use it like that. It's quite clear in the example below. What's the result that you were going to achieve?

Relationships_not_working_even_though_they_have_been_created

Now, we create a table visual.

asset code    asset classification       product type

computer     electricl equipment      ??? (type 1? type 2? type 3? type 4?)

 

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ajprosser Frequent Visitor
Frequent Visitor

Re: Relationships not working even though they have been created

Thanks Dale @v-jiascu-msft - I saw what was going on after I posted in abject frustration! My bad