Forum Discussion
Fail to upload a Direct query report with data store in Postgres due there's no data gateway
Hello! You can refresh data from Power BI service without a gateway if PostgreSQL is hosted in a way that allows direct connection from Power BI Services on Azure. If your PostgreSQL is hosted on Azure, this is natively supported, but if it is hosted on another environment you would have to check with that provider to see about configuring to allow for direct access. Also, if PostrgeSQL is configured to prevent direct access from the interenet (which if often recommended for security reasons), you'll need the gateway.
Guidance for deploying a data gateway for the Power BI service - Power BI | Microsoft Learn
Since yours is on-prem you absolutely need a standard gateway. If you were hosting it on Azure you wouldn't need a gateway. If you were hosting it on some out cloud server, you would need to see with that server if it is possible for direct connection without a gateway (and of course, your IT team).
Thx a lot Audrey.