cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Relationship error

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?

1 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!

 

 

View solution in original post

4 REPLIES 4
Community Support
Community Support

Hi @smatesic,

 

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

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Community Champion
Community Champion

It could be the visual selected only supports aggrgated data.

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

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!

 

 

View solution in original post

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.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors