Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Scheduled refresh error

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's avatar
    v-deddai1-msft
    6 years ago

    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