The remote server returned an error: (400) Bad Request. (Number of calculated fields in query excee

[bhavana097]

Hello everyone!

I'm getting the following error for the past 5 days, Although it was working fine until now 
The table was working fine & loading & refresh data all these days & suddenly I encountered this error.
Due to this I'm not able to refresh the data & all reports linked to this table have stopped working. Please help me resolve this issue.
Reports have gone live long back But I recently encountered this error. Stopped working 

Your help is much appreciated 
Thank you in advance🙂

[bhavana097]

Hello @olgad, Thank you for your reply.
However It is not allowing me to load the table to rework on fewer columns, I even tried to select the column in Advanced Editor & still didn't work 
I'm getting this error right from the navigation in editor 

Data sources for the Power BI service - Power BI | Microsoft Learn

[olgad]

You have exceeded the number of allowed calculated fields which is 50. try to rework and have fewer than that