Forum Discussion
Power BI Report Builder - PostgreSQL
Our database server is PostgreSQL.
How do i connect my PostgreSQL database with Power BI Report Builder?
Hi gulfamahmad
Thanks for reaching out to us.
(1) For Power BI Report Builder Embedded data sources PostgreSQL is not supported, only the following are supported:
- Azure SQL Database and Azure Synapse Analytics (via Basic and oAuth)
- Azure Analysis Services (via SSO)
- SQL Server via a gateway
- Power BI datasets
- Oracle
- Teradata
See Supported data sources for Power BI paginated reports for a complete list.
(2) if you want to connect to other data source like PostgreSQL Server then below are the 2 ways that we can follow.
Article link: Publish Power BI Paginated Reports with Azure PostgreSQL | WinWire
(3) Power BI gateway and Report Builder support for ODBC data sources
Article link: Power BI gateway and Report Builder support for ODBC data sources (preview) - Power BI | Microsoft Docs
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
- v-xiaotangCommunity Support
Hi gulfamahmad
Thanks for reaching out to us.
(1) For Power BI Report Builder Embedded data sources PostgreSQL is not supported, only the following are supported:
- Azure SQL Database and Azure Synapse Analytics (via Basic and oAuth)
- Azure Analysis Services (via SSO)
- SQL Server via a gateway
- Power BI datasets
- Oracle
- Teradata
See Supported data sources for Power BI paginated reports for a complete list.
(2) if you want to connect to other data source like PostgreSQL Server then below are the 2 ways that we can follow.
Article link: Publish Power BI Paginated Reports with Azure PostgreSQL | WinWire
(3) Power BI gateway and Report Builder support for ODBC data sources
Article link: Power BI gateway and Report Builder support for ODBC data sources (preview) - Power BI | Microsoft Docs
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.