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

[JHonig]

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))

[v-qiuyu-msft]

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 

[JHonig]

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