Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
Solved! Go to 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?
Hi @MatiwosG ,
Just as GilbertQ said.
Download pbix file ,and check on Power BI Desktop.
Best Regards
Lucien
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?