memory allocation error when fetching data from view .?

[suvechha]

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

[v-zhangti]

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.

[amitchandak]

@suvechha , Try to reduce no of rows by using some filters and try