Forum Discussion

suvechha's avatar
suvechha
Helper IV
4 years ago

memory allocation error when fetching data from view .?

Hi there,

 

I have a view in my sql server db which contain around 3,984,175 rows data  and 157 columns , 

I am getting an error like below

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support

    Hi, suvechha 

     

    Remedies for insufficient memory.

    1. Scale up the capacity - scaling up the capacity to the next SKU will make available twice the amount of memory than the current SKU, thus alleviating any memory and CPU pressure the capacity is currently experiencing.

     

    2. Move datasets to another capacity - if your wait times are being caused by memory pressure and you have another capacity that has more memory available, you can move the workspaces that contain the datasets that are waiting to the other capacity.

     

    3. Spread out scheduled refreshes - spreading out the refreshes will help to avoid too many refreshes attempting to execute concurrently.

     

    Please refer to the following documents to see if they are helpful.

    Power BI Premium Metrics app - Power BI | Microsoft Docs

    Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs

     

    Best Regards,

    Community Support Team _Charlotte

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