Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Reply
achourey
New Member

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

‎04-15-2024 09:38 PM

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?

Labels:
Message 1 of 2
1,856 Views
0
1 ACCEPTED SOLUTION
collinq
Super User
Super User

‎04-16-2024 01:53 PM

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

Message 2 of 2
1,815 Views
1 REPLY 1
collinq
Super User
Super User

‎04-16-2024 01:53 PM

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.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Message 2 of 2
1,816 Views

Helpful resources

Announcements
May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All