Forum Discussion

tgg3's avatar
tgg3
Helper I
6 months ago
Solved

PostgreSQL Reports Not Refreshing On Web Page

Hello,   I have several Power BI PostrgeSQL DB reports that were developed in the desktop app and uploaded to the web site of our on-prem Report Server. In the desktop app they refresh as they shou...
"PostgreSQL"
power bi
  • v-echaithra's avatar
    v-echaithra
    4 months ago

    Hi tgg3 ,

    Thanks for the update, since the error occurs while saving the scheduled refresh, this points more toward a scheduling/configuration issue rather than the data source.

    We recommend checking the following:

    Ensure SQL Server Agent is running and review Job/Agent logs
    Verify Report Server service account permissions on the ReportServer database
    Check PBIRS logs (LogFiles folder) at the time of saving the schedule
    Review Windows Event Viewer (Application logs) for any related errors

    Additionally, try creating a schedule for a simple test report to confirm if this is environment related.

    Please let us know what you find, and we’ll assist further.

    Thank you,
    Chaithra E.

v-echaithra's avatar
v-echaithra
Community Support
5 months ago

Hi tgg3 ,

Since the connection test succeeds but the report does not refresh, the next step is to check the Power BI Report Server logs to confirm whether the dataset execution is being triggered.
If the report has no scheduled refresh configured, the dataset will only refresh during report execution. After saving the data source credentials, try opening the report with a hard refresh to ensure the dataset execution is triggered.
Look for files like ReportServerService_*.log and search for the report name, PostgreSQL, or Npgsql. These logs will show if the refresh is executed and whether there are any driver or data source errors.
Since you previously saw the Npgsql 4.0.10 message, the logs will also confirm whether the PostgreSQL driver is being correctly loaded by the Report Server service. Please check the logs and let us know if you see any related errors.

Kind Regards.