cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
summitb
Level: Powered On

Error showing "No of calculated field in query exceeded maximum limit of 10"

I am creating an app from a data source with 4098 records. Is there any limitation of record to that the data source can have a certain number of records only. Is there any way this can be solved?

 

Untitled-1.jpg

7 REPLIES 7
r529
Level: Powered On

Re: Error showing "No of calculated field in query exceeded maximum limit of 10"

I began encountering this same error today after updating Project Service Automation to 3.x.  Specifically, I encounter this error when attempting to connect to the msdyn_project entity.

Community Support Team
Community Support Team

Re: Error showing "No of calculated field in query exceeded maximum limit of 10"

Hi @summitb,

Could you please share a bit more about the data source used within your app? Is it a Dynamics 365 Entity?

Currently, I could not reproduce your issue on my side.

I have found similar issue with you, please check the following thread:

https://community.powerbi.com/t5/Integrations-with-Files-and/New-error-Dynamics-365-Number-of-calcul...

 

I think it is a known limit that the Saved queries, charts, and visualizations can have a maximum of 10 unique calculated fields.

More details about the Calculated fields limits, please check the following article:

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/dn832...

Please check if the number of unique calculated fields in your Dynamics 365 Entity is more than 10.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
summitb
Level: Powered On

Re: Error showing "No of calculated field in query exceeded maximum limit of 10"

Yes, the calculated fields are more than 10. The app is working on the dev environment but not in the production. I won't be able to share my datasource in the forum. Is it any way I can talk share the issue with someone is private?

r529
Level: Powered On

Re: Error showing "No of calculated field in query exceeded maximum limit of 10"

In my case the number of calculated fields exceeds 10 in both my production and sandbox environments.  However, the problem only occurs in the sandbox environment after updating Project Service Automation to 3.0.  

 

I would also point out that this also affect Power BI queries and Microsoft Flow references.  Queries to the msdyn_project entity now return the same error message of  "Number of calculated fields in query exceeded maximum limit of 10."

 

Since the ShowColumns function appears to be non-delegable, are there other methods for specificy the return of only certain attributes - in the same way I would normally call the web api for D365? 

NielsL
Level: Powered On

Re: Error showing "No of calculated field in query exceeded maximum limit of 10"

@summitb @r529 

 

Did you find a solution to this? 

Everything is working fine in my Sandbox environment. But now that I have moved it to Production, I'm suddenly getting the "No of calculated field in query exceeded maximum limit of 10" error.

 

in my case it is a flow, that doesn't work. 

r529
Level: Powered On

Re: Error showing "No of calculated field in query exceeded maximum limit of 10"

Yes.  Actually two solutions.

 

One, was that it just fixed itself.  I suspect there must have been a bug in the API that got fixed in a later update.

 

Two - and this was my temporay workaround until it got fixed - was to create a custom connector in PowerApps to D365.  With that I could specifify only certain field to come in to the app and didn't hit the 10 field limit.  I followed thttps://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/walkthrough-register-dyna... , https://docs.microsoft.com/en-us/connectors/custom-connectors/define-blank, and https://docs.microsoft.com/en-us/connectors/custom-connectors/define-postman-collection.  It was an educational experience.

NielsL
Level: Powered On

Re: Error showing "No of calculated field in query exceeded maximum limit of 10"

Thanks for the feedback, @r529 .

 

Using a custom connector seems a bit too much for me. I managed to get rid of some calculated fields one or another way to get down to 10 - but I would rather have avoided that. 

 

I don't know if it is a bug or not - but having a limit of calculated fields related to queries in a Production instance and not in Sandbox is really not a nice surprise to get close to go-live Smiley Surprised

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 166 members 5,338 guests
Please welcome our newest community members: