Forum Discussion
Scheduled Refresh Fails
It was working then stopped a little while ago. I beefed up the Azure SQL server being pulled from and in the refresh settings it says "Last Refresh Succeeded: null". Refresh history seems to think it's still in progress.
In the reports all the visuals have broken:
Couldn't load the data for this visual
Memory error: The memory used for the current operation exceeds the memory limit for the workload group '50d9da4c-ffb7-4b58-b248-bb72814fc2fc-ResourceGroup'.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 1efbf40f-e62d-4387-b630-e8fa7f659e34
Request ID: affffcf9-def9-8f2e-5205-92de61ee2035
Correlation ID: 53aa98b5-2ac8-1e99-397a-d51ee76889da
Time: Fri Nov 09 2018 17:32:44 GMT+0000 (GMT Standard Time)
Version: 13.0.7302.190
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net
Help Appreciated. The data being pulled in is <1GB, from P2 SQL DB's.
1 Reply
Hi Anonymous,
As we can see from the error message, there is a shortage of memory. I would suggest you reduce the data size and try again. Please refer to power-bi/refresh-troubleshooting-refresh-scenarios#uncompressed-data-limits-for-refresh.
The log said: Memory error: Memory Allocation failure. Try simplifying or reducing the number of queries.
1. What's the P2 SQL DB?
2. Do you have a premium capacity?
Best Regards,
Dale
