Getting Out Of Memory issue with Power BI Gateway when I am trying to refresh a large dataset.

[achourey]

my database is Amazon Redshift db and I am trying to refresh a report which consists of the last 3 months of my prod data which has around 200 million.
when I refreshed the report, I got the gateway of memory issue and I used the Amazon m5.2xlarge gateway EC2 instance, which has 8 vcpu ,32 GB RAM and 10 GB.
Can anyone help to resolve this issue?

[collinq · Accepted solution]

Hi @achourey ,

When I have experienced this the solution has always been to upgrade the RAM on the gateway server.  It might not be that just your single refresh is the problem.  It could be that other reports are running or other items on the server itself.  I would review the logs on the server itself for the gateway and look at how many times and when the memory (or cpu) got pegged at 100% and how long it stayed there.  It is usually as simple as adding more RAM to the gateway.