cancel
Showing results for 
Search instead for 
Did you mean: 

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

Hi

 

I get the following error when adding a table from Dynamics 365

 

 

DataSource.Error: OData: Anmodningen lykkedes ikke: Fjernserveren returnerede en fejl: (500) Intern serverfejl. (Number of calculated fields in query exceeded maximum limit of 10.)
Detaljer:
    DataSourceKind=OData
    DataSourcePath=https://qvartz.api.crm4.dynamics.com/api/data/v9.0/viv_employees
    Url=https://qvartz.api.crm4.dynamics.com/api/data/v9.0/viv_employees

 

My problem is, that i have no way of deselecting some of the calculated fields in the query to make it work. The "Remove columns" button is disabled. 

 

I use Power BI Desktop latest version (2.61.5192.541 64-bit (august 2018))

 

Power BI error.PNG

 

Status: New
Comments
Moderator

Hi @JHonig,

 

The error is coming from the Dynamics CRM side, I would suggest you contact the Dynamics CRM for help and ask them the reason for such error. 

 

Best Regards,
Qiuyun Yu 

New Member

Hi Qiuyun Yu

 

Thanks for the reply. 

 

I would suggest that the Power BI team and the Dynamics 365 team get together and solv the issue :). 

 

Br 

Jacob