I have a Table in Dataverse and recently I am getting this warning.
Is it because of the relations I have created with other tables?
In this table I have 7 Many-to-Many, 11 On-to-Many relations.
In another post someone has stated that the limit is 10. Is there any official document for this?
That is correct. Dataverse limits a table to 10 relationships, this includes any relationship that appears in the Relationships tab. There are some circumstances where a connector is being used which does not result in a relationship being created, those would not count against the relationship count.
Does this mean that I can only create 10 custom relations with other tables?
Also I am saving Images in the table and it has create two relations with "Sharepoint Document" and "Document Location". Does that also counts as extra?
You are limited to 10 additional keys per table, this is likely the limit you are hitting.
Hi @Usman2 ,
Honestly the only think I can think of here is to open a case with Microsoft or to restructure your tables to remove the number of relationships. Sorry.
Thanks,
Drew
Hi @dpoggemann
Yes it is from my Canvas App and this warning is coming from wherever I am using this table even in a gallery to show the records without any filters.
Hi @Usman2,
Where are you hitting this? I assume it is in a Fetch XML Query of some type? Is it in your canvas app? You aren't seeing this in the Dataverse itself right? I know of no official documentation except for the documentation / examples related to the article you posted.
Thanks,
Drew
stampcoin
17
mmbr1606
13
Super User 2025 Season 1
ankit_singhal
11
Super User 2025 Season 1