Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@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
@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
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.
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.
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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.