Cannot display visual - no connection in model

[Anonymous]

Hi,

When I create table that shows both unit_name and unit_type_id from tables 1 and 3 everything works.

When I create table that shows both unit_id and unit_type_id from tables 5 and 3 again - everything works.

But when I try to show all of that columns in one table I get error "Can't display visual". Details say there is no connection in model, but as you can see ther are.

Table number 2 just connects 1 and 3.

Table 4 filters only one name of types on all pages.

[v-shex-msft]

Hi @Anonymous ,

It seems like your fields not mapping correctly when you use all fields in the same visual. According to your snapshot, I found some tables are linked with single-mode relationships.
I'd like to suggest you change them to double-mode or remove these single-mode table fields to confirm if this issue related to them.

What is the Direction of Relationship in Power BI? 

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Hi,

I tried your solution and it didn't work but I had to rebuilt my model anyway. I think the problem was solved once I joined tables into one bigger so probably something was wrong with the relationships as you say.