cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
scottogtc Frequent Visitor
Frequent Visitor

New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

We started getting an error a few weeks ago on our powerbi dashboard.  The data source is Dynamics 365 - we run version 9 however were using the v8.2 API url.  This worked fine however now getting the following error when pulling one of the tables to powerbi - this is happening when we reference v9 or v8.2

 

DataSource.Error: OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Number of calculated fields in query exceeded maximum limit of 10.)
Details:
DataSourceKind=OData
DataSourcePath=https://private.api.crm4.dynamics.com/api/data/v9.0/ic_sparks
Url=https://private.api.crm4.dynamics.com/api/data/v9.0/ic_sparks

 

My colleague spotted it as a known issue that was supposedly fixed relating to v9 - see below - has this "fix" impacted us?

 

PB144068 - OData can’t connect to Dynamics CRM

Status:
Service restored
User impact:
Users were unable to connect to Dynamics CRM 9.0 using the OData connector in Power BI Desktop and Power BI Service.
Latest message:
Title: OData can’t connect to Dynamics CRM User Impact: Users were unable to connect to Dynamics CRM 9.0 using the OData connector in Power BI Desktop and Power BI Service. More info: Users that were impacted would have seen a connector error stating that the feed's metadata document appeared to have been invalid. Final status: We've deployed the long-term solution to the affected environment and we performed validation tests to confirm that the issue is resolved. Scope of impact: All users connecting to Dynamics CRM 9.0 using the OData connector in Power BI Desktop may have been impacted. Start time: Thursday, June 7, 2018, at 7:47 AM UTC End time: Friday, July 27, 2018, at 11:23 AM UTC Preliminary root cause: An update intended to improve the structure of OData feeds resulted in impact. Next steps: - We're reviewing our update procedures to better identify similar issues during our development and testing cycles. This is the final update for the event.
1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

@scottogtc,

The known issue you mentioned has nothing to do with your issue. The above error message comes from Dynamics 365 side, see the Calculated fields considerations  part in this article.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
Moderator v-yuezhe-msft
Moderator

Re: New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

@scottogtc,

The known issue you mentioned has nothing to do with your issue. The above error message comes from Dynamics 365 side, see the Calculated fields considerations  part in this article.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

scottogtc Frequent Visitor
Frequent Visitor

Re: New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

thanks for info - i had a call with support yesterday and came to this conclusion - appreciate your engagement and the reference to the considerations - handy to know for future. 

VickyDev Frequent Visitor
Frequent Visitor

Re: New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

I am getting this error and my entity that I need to query DOES have more than 10 calculated fields. I don't need to bring all the fields into PowerBI. How do I exclude these fields when initially loading the entity. I don't have a chance, yet, to eliminate the columns/fields that I do not need. 

owenqh Frequent Visitor
Frequent Visitor

Re: New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

Same question here: How do I exclude these fields when initially loading the entity. I don't have a chance, yet, to eliminate the columns/fields that I do not need.

twinrabbits
Advisor

Re: New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

Looking for the same 

How do I exclude these fields when initially loading the entity. I don't have a chance, yet, to eliminate the columns/fields that I do not need.

owenqh Frequent Visitor
Frequent Visitor

Re: New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

@twinrabbits any luck you have?

twinrabbits
Advisor

Re: New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

No luck yet. The problem is I am unable to connect to the table before even filtering out any fields. If I find a solution I will post here.

owenqh Frequent Visitor
Frequent Visitor

Re: New error Dynamics 365 Number of calculated fields in query exceeded maximum limit of 10.

@twinrabbits same here. Thanks. 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors