- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @smatesic,
Can you share us mode detail about your issue? It will be help for troubleshooting.
Regards,
Xiaoxin Sheng
If this post helps, please consider accept as solution to help other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It could be the visual selected only supports aggrgated data.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Subject | Author | Posted | |
---|---|---|---|
08-21-2024 11:09 PM | |||
10-15-2024 09:58 AM | |||
09-23-2024 07:02 PM | |||
12-19-2024 08:11 AM | |||
12-05-2024 02:00 AM |
User | Count |
---|---|
137 | |
107 | |
85 | |
59 | |
46 |