PowerBI Enterprise Gateway with Postgres

[bernardoflynn]

We are currently usuing Personal Gateway to refresh reports where the data is stored in Postgres. We want to refresh more often so we're looking at using Enterprise gateway.

However there is no Postgres Data Source listed as an option when setting up the data sources in the gateway.

Does anyone know how we add it?

[ankitpatira]

@bernardoflynn Check out this list of supported data sources. Since Postgres isn't supported yet you may have to find intermediate solution by exporting tables to file or having SQL Server so that it can work with data gateway. I will also refer you to this article which walks through setting up Postgres in power bi and suggest you also contact @ashishrj as he may have setup refresh before.

[bernardoflynn]

Thanks but how can MS support it on the gateway personal but not in the gateway enterprise???

[v-yuezhe-msft]

Hi @bernardoflynn,

Please add your vote in the following idea to help Power BI team prioritize this feature that connecting to PostgreSQL with the Enterprise Gateway.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11328981-postgresql-datasource-fo...

Thanks,
Lydia Zhang