Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
IuteJV
Frequent Visitor

Report Server Configuration manager - connect to PostgreSQL server and database

Hi

 

Seems like a really simple task, but unfortunately, this is my first time setting up PowerBI RS. I am having issues making the database connection in the configuration manager to our PostgreSQL database. 
In the configuration manager in the "Database" section one can only go to "Change Database" button, after that a new prompt appears with "Create a new report server database", "Choose an existing report server database". Since I don't have any database present, I would go with the first one. --> Create a new report server database.

After that a page appears (see below), when I try to input the PostgreSQL server IP there I get an error.

IuteJV_0-1727962364560.png

IuteJV_1-1727962790984.png

I know I am doing something wrong, can somebody possibly provide some steps/actions to take to completly configure the database connection.

1 ACCEPTED SOLUTION


@IuteJV wrote:

My question is now more about, when I use Postgre as a db source for reports. How would the refresh work in the RS. I have currently created a ODBC connection to access postgre db for my reports. But not sure how the refresh would work or would not work.


So you don't configure data sources for the report through the configuration manager, you just add them directly in your report. Postgres is listed as a supported data source here Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn so it should work fine. Note that you may need to install the NgpSQL 4.0.10 provider on the server - I don't use Postgres so I'm not sure if that is included in the server install. see Power Query PostgreSQL connector - Power Query | Microsoft Learn 

 

ODBC is also supported on Report Server, but you will need to make sure the same driver is installed on the client machines for building reports and on the server so it can run the refreshes.

View solution in original post

9 REPLIES 9
d_gosbell
Super User
Super User

This is because the Report Server catalog database needs to be installed on a Microsoft SQL Server instance, you cannot put that database on Postgres.

@d_gosbell I get that part. I will install MSS instance to faciliate RS catalog. I initially thought, that maybe we can add postgre as a source in the RS as well, but that is not happening.
My question is now more about, when I use Postgre as a db source for reports. How would the refresh work in the RS. I have currently created a ODBC connection to access postgre db for my reports. But not sure how the refresh would work or would not work.


@IuteJV wrote:

My question is now more about, when I use Postgre as a db source for reports. How would the refresh work in the RS. I have currently created a ODBC connection to access postgre db for my reports. But not sure how the refresh would work or would not work.


So you don't configure data sources for the report through the configuration manager, you just add them directly in your report. Postgres is listed as a supported data source here Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn so it should work fine. Note that you may need to install the NgpSQL 4.0.10 provider on the server - I don't use Postgres so I'm not sure if that is included in the server install. see Power Query PostgreSQL connector - Power Query | Microsoft Learn 

 

ODBC is also supported on Report Server, but you will need to make sure the same driver is installed on the client machines for building reports and on the server so it can run the refreshes.

Thank you! Much appreciated! 

IuteJV
Frequent Visitor

Could anyone please clarify the following:
How the refresh process/setup would look like when using PostgreSQL db as a source? In PBI one would have a gateway to access the database and run the refreshes on. But for PBIRS I would assume I would need to access postgre db using ODBC to have the refresh running? Would that be correct? Do you also know any limitations on using said approach, aka the number of refreshes running at the same time, etc.

lbendlin
Super User
Super User

Wait what - are you trying to run PBIRS on PostGreSQL?  I think only SQL Server is supported.

Yes, the idea was to have the data in PostgreSQL and then build PowerBI reports from that datasource. But if PostgreSQL is not supported for PBIRS, can I still connect to that datasource and will it refresh like it would with a SQLServer db?

Sure, but keep in mind these are two very (VERY) different concepts. Make sure you are clear on what you are trying to achieve.

Can you perhaps elaborate, how the refresh process/setup would look like? In PBI could you would have a gateway to access the database and run the refreshes on. But for PBIRS I would assume I would need to access postgre db using ODBC to have the refresh running? Would that be correct? Do you also know any limitations on using said approach, aka the number of refreshes running at the same time, etc.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.