What is the limit of creating relations in a Dataverse table?

(0) Share

Report

Posted on by Usman2

124

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Usman2 124 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nhelgren Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

You are limited to 10 additional keys per table, this is likely the limit you are hitting.

Was this reply helpful? Yes No
Usman2 124 on at

Like (0)

Report
Copy link

Link copied!

@NHelgren
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?

Was this reply helpful? Yes No
Nhelgren Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No