Power BI Desktop Error Message

[prasannakrishna]

While i am trying to load my data from my online sevices , error displays like this

OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Number of calculated fields in query exceeded maximum limit of 10.)

[prasannakrishna]

While i am tying to load data from my source error getting like this

OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Number of calculated fields in query exceeded maximum limit of 10.)

[Anonymous · Accepted solution]

HI @prasannakrishna,

It seems like your calculated fields in query has exceeded to limit so you get 500 error. Please reduce calculate fields amount to work thought this issue.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Anonymous,

Can you please elaborate how would we do so? I cannot choose "Remove Columns" as the screen just shows the error message. Thank you.