https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-Service-Cache-Error/m-p/3076616#M28837 <P>Hi Everyone</P><P>&nbsp;</P><P>I am doing a schedule refresh and I am getting the following error, anyone who can kindly advise?</P><P>&nbsp;</P><P>Data source error: We're sorry, an error occurred during evaluation.;The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: DimDataAgentDetails.<BR />Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net<BR />Activity ID: 6f4ef2f1-7c3d-4e4c-bfde-5af81f3641fa<BR />Request ID: 68b7f84b-1dc9-4e2f-b3d3-8f478ae38dd8<BR />Time: 2023-02-12 14:31:50Z</P> Sun, 12 Feb 2023 18:53:43 GMT Anonymous 2023-02-12T18:53:43Z https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-Service-Cache-Error/m-p/3076616#M28837 <P>Hi Everyone</P><P>&nbsp;</P><P>I am doing a schedule refresh and I am getting the following error, anyone who can kindly advise?</P><P>&nbsp;</P><P>Data source error: We're sorry, an error occurred during evaluation.;The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: DimDataAgentDetails.<BR />Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net<BR />Activity ID: 6f4ef2f1-7c3d-4e4c-bfde-5af81f3641fa<BR />Request ID: 68b7f84b-1dc9-4e2f-b3d3-8f478ae38dd8<BR />Time: 2023-02-12 14:31:50Z</P> Sun, 12 Feb 2023 18:53:43 GMT https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-Service-Cache-Error/m-p/3076616#M28837 Anonymous 2023-02-12T18:53:43Z https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-Service-Cache-Error/m-p/3077300#M28838 <P>To resolve this issue, you can try the following steps:</P><OL><LI><P>Increase the cache size limit: You can increase the cache size limit to allow for larger query evaluations. This can be done in the settings for your data source.</P></LI><LI><P>Optimize the query: If increasing the cache size limit is not feasible, you can try optimizing the query by reducing the number of columns, filtering the data, or using a different aggregate function.</P></LI></OL> Mon, 13 Feb 2023 08:55:15 GMT https://community.fabric.microsoft.com/t5/Report-Server/Power-Bi-Service-Cache-Error/m-p/3077300#M28838 jaweher899 2023-02-13T08:55:15Z