cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bernardoflynn
Frequent Visitor

PowerBI Enterprise Gateway with Postgres

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?

3 REPLIES 3
ankitpatira
Community Champion
Community Champion

@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.

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

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors