Relationship error

[smatesic]

Hi everyone,

I have unexpected error in my power bi report. I have around 20 different tables (their sources are sp lists and documents library, I used SP Online List and OData as data sources in PBI) and all tables are connected. I checked all connections multiple times, everything is as it shoud be. 

When I build report, and use values from different tables everything is OK. My visual works. But if I select table visual, and on numeric fields set Don't summarize option I get Can't display visual, can't determine the relationship between the fields error. 

When I select Sum option, it works and shows data. 

I have 5 pages, all of them contain table visual with fields from multiple tables. I'm having this issue only on two of them. The interesting thing is - one table visual that is not colapsing and not showing the error contains same plus some more fields from tables that are used in table visual that is collapsing - in other words Table visal that has fields from tables let's say Phases, People, Project, Invoices, Resources is fine and table visual that has Phases, People and Project is showing the error.

I know it's hard to say anything without looking at data, but does someone has an idea why is this happening?

[Anonymous]

Hi @smatesic,

Can you share us mode detail about your issue? It will be help for troubleshooting.

Regards,

Xiaoxin Sheng

[BhaveshPatel]

It could be the visual selected only supports aggrgated data.

[smatesic · Accepted solution]

No, it's table visual, it supports these actions.

Unfortunately, I can't show data model but I contacted SP group and apparantely it has something to do with the way lists and libraries are connected. It is in general relationship problem but in my power bi it manifested itself in showing the error when choosing don't summirize option in some tables for only couple of columns. 

I worked around these tables and columns and now my report is stable. 

It's maybe not a solution, but considering, I don't think it really is a power bi problem. 

Regards!

[Anonymous]

This does not seem to provide any solution to the problem.  Does anyone know of a solution to this problem which I will describe again.  

I have a numeric field in a Table visual that displays just fine when it is set to summarize by any of the summarization choices (Sum, Ave, Count etc), when I try and change the summarization on that field to "Don't Summarize" I get the error "Can't dispaly the visuals", details "Can't determine relationships between the fields"

Thx in advance for any help offered.