Forum Discussion
Power Bi Enterprise Gateway Memory Usage
Adjust gateway performance based on server CPU | Microsoft Docs has info on this, but your gateway should not be on the production SQL server. That server should dedicate 100% of resources to Power BI.
The gateway should be on a separate machine (not a domain controller) where memory is available or even a beefy workstation. See On-premises data gateway sizing - Power BI | Microsoft Docs for sizing recommendations.
But pull it off of the database server. That will slow the server down, or radically slow the report refreshes down, or both.Ok. I'll mark that as a solution. But remember that a gateway does not need to be on a server. Buy a cheap desktop with 16-32GB of RAM, install Windows 10 on it, install the gateway and call it a day.
Community ChampionAdjust gateway performance based on server CPU | Microsoft Docs has info on this, but your gateway should not be on the production SQL server. That server should dedicate 100% of resources to Power BI.
The gateway should be on a separate machine (not a domain controller) where memory is available or even a beefy workstation. See On-premises data gateway sizing - Power BI | Microsoft Docs for sizing recommendations.
But pull it off of the database server. That will slow the server down, or radically slow the report refreshes down, or both.
Thanks for your response.
But, we do not have another machine where we can put the gateway on to. We are small organisation and only running a VPS which is hosted with a third party provider. Basically, we have one server running IIS, MSSQL and PowerBi.
I'll review the link you provided on adjusting gateway performance, hopefully that helps.- edhans
Ok. I'll mark that as a solution. But remember that a gateway does not need to be on a server. Buy a cheap desktop with 16-32GB of RAM, install Windows 10 on it, install the gateway and call it a day.
Ok thanks Edhans, so the gateway can be on any machine on any network right?
