Scheduled refresh issue

[MatiwosG]

The report used to refresh fine with out any problem. Now I’m seeing the following error message and Scheduled refresh failed.

When I run the query it only have 1490 rows.  

Processing error:	Query execution has exceeded the allowed limits (80DA0003): Query result set has exceeded the internal record count limit 500000 (E_QUERY_RESULT_SET_TOO_LARGE;
Cluster URI:	DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID:	93a8b80a-e40e-4459-903a-8120640b36db
Request ID:	d060d4e2-c16f-4167-b802-37929f5a49f0
Time:	2021-04-28 07:20:35Z

[v-luwang-msft]

Hi @MatiwosG ，

Just as GilbertQ said.

Download pbix file ,and check on Power BI Desktop.

Best Regards

Lucien

[GilbertQ · Accepted solution]

Hi @MatiwosG 

Could it be that there is a variable that is causing the results to store over 500000 rows in the variable?

I would test the query in PBI desktop to make sure that it does not exceed the amount of rows?