Forum Discussion

MatiwosG's avatar
MatiwosG
Microsoft Employee
5 years ago
Solved

Scheduled refresh issue

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
Need Help
  • GilbertQ's avatar
    GilbertQ
    5 years ago

    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?

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    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?

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    5 years ago

    Hi MatiwosG ，

    Just as GilbertQ said.

    Download pbix file ,and check on Power BI Desktop.

     

    Best Regards

    Lucien