Forum Discussion
Paginated Reports - Data Source connection error
Hi raima
Here is an example of how you can install and configure PostgreSQL through the gateway in Power BI Configuring Power BI Connectivity to PostgreSQL Database - oxcrx34285 (microsoft.com)
Hi GilbertQ ,
I use PowerBi Report Builder to create the paginated report. I would prefer to hava a connection via a gateway on PowerBI Service which I can use for the paginated report, but as i stands this is currently not supported.
I don't use PowerBI Desktop because I believe ther is not an appropriate/easy way to create a paginated report in PowerBI Desktop.
Hi raima
Agree with GilbertQ, I think you should use ODBC in Power BI Desktop to connect to PostgreSQL and then publish to Service. so that you can connect to this semantic model in Power BI Report Builder.
Please refer to:
Publish Power BI Paginated Reports with Azure PostgreSQL | WinWire
Power BI gateway and Report Builder support for ODBC data sources - Power BI | Microsoft Learn
Here is PostgreSQL ODBC drivers link:
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.