Forum Discussion

IuteJV's avatar
IuteJV
Frequent Visitor
1 year ago
Solved

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 PostgreSQ...
"PostgreSQL"
"Power BI Report Server "
Configuration Manager
  • d_gosbell's avatar
    d_gosbell
    1 year ago
    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.

d_gosbell's avatar
d_gosbell
Super User
1 year ago
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.

IuteJV's avatar
IuteJV
Frequent Visitor
1 year ago

Thank you! Much appreciated!