Scheduled refresh error

[Anonymous]

I have checked the data sets all being correct and then credientels too.. Even then some error is occuring as you have reached the maximum allowale memory

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

When the data is refreshed, twice the size of the dataset is required. The reason for the error reported by you may be that multiple data sets are refreshing at the same time, or the amount of data you need to refresh is too large.

I suggest you optimize the data source to reduce the amount of data refresh. To avoid merging transformations from different data sources, make sure to set the appropriate data source privacy level, which avoids requiring Power BI to load the complete results to generate combined results across queries. Delete useless columns and rows in power bi.  You can use incremental refresh, which can significantly shorten the refresh time and save memory and CPU.

If the above optimized content still cannot prevent the refresh failure, I suggest you scale-up an existing Premium capacity or add a new Premium capacity with more available memory.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , refer if this can help

https://community.powerbi.com/t5/Service/Memory-Error-while-refreshing-the-dataset-in-Power-BI-Service/td-p/957492

https://social.msdn.microsoft.com/Forums/en-US/2c78276b-922b-4ab0-92b2-5859448e5fb4/you-have-reached-the-maximum-allowable-memory-allocation-error-in-tabular-model?forum=AzureAnalysisServices

https://community.powerbi.com/t5/Service/Error-reached-the-maximum-allowable-memory-allocation-for-your/td-p/904303

[lkalawski]

Hi @Anonymous ,

You exceeded the memory range. You probably have a lot of data to refresh, right?
To reduce the amount of data it is best to use Incremental Refresh.
Please check this: https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

_______________
If I helped, please accept the solution and give kudos! 😀