Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Reply
cdwilson100
Regular Visitor

Minimum Spec for Power BI Gateway

Hi

 

We have a small data warehouse which is currently just less than 3MB in size. I expect the maximum size that it will reach would be 50MB. The recommended minimum spec for a server acting as a Power BI gateway is as follows

 

  • An 8-core CPU
  • 8 GB of memory
  • A 64-bit version of Windows Server 2012 R2 or later
  • Solid-state drive (SSD) storage for spooling.

 

Due to the small size of our Data Warehouse, what would be the smallest configuration that we could use for the gateway?

 

We are also investigating creating a VM in Azure to act as the power bi gateway. The reports will be refreshed overnight and I would like to know whether we could shut the server down and only run it when the reports were refreshed probably between 01:00AM->06:00AM. We would like to keep costs to a minimum.

 

Any advice would be gratefully received.

 

Kind regards


Chris

5 REPLIES 5
kcwilsonii1
Frequent Visitor

The latest spec is for Windows Server 2019

Install an on-premises data gateway | Microsoft Learn

Greg_Deckler
Community Champion
Community Champion

@cdwilson100 - I would say you could probably try halving those specifications and give it a whirl, mabye even on a Windows 10 device honestly. Now, none of what I just said is best practice, but if you want to see what you can get away with, try it out on an Azure VM and see how it goes.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Thank you for your reply Greg, I will investigate the different configurations with a VM in Azure and let you know the outcome. 

 

Kind regards

 

Chris

Would you recommend shutting down the Power BI gateway and only run it overnight to refresh the data in the reports?

Hi @cdwilson100 ,

 

Just make sure that the gateway service is running when the the scheduled refresh is in progress.

 

Best regards,
Lionel Chen

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

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

Vote for your favorite vizzies from the Power BI World Championship submissions!

Sticker Challenge 2026 Carousel

Join our Community Sticker Challenge 2026

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

January Power BI Update Carousel

Power BI Monthly Update - January 2026

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.