Forum Discussion

achourey's avatar
achourey
New Member
2 years ago
Solved

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

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...
Need Help
  • collinq's avatar
    collinq
    2 years ago

    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.

collinq's avatar
collinq
Icon for Super User rankSuper User
2 years ago

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.