Forum Discussion
PostgreSQL Reports Not Refreshing On Web Page
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 errorsAdditionally, 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.
Hi tgg3 ,
Thank you for the update and for sharing the additional details.
Since your PostgreSQL instance is running on Linux with MD5 username/password authentication, the recommended approach is to configure stored database credentials for the report’s data source in Power BI Report Server. This allows the report server to authenticate directly to PostgreSQL using the database account instead of relying on Windows authentication or the gMSA service account.
You can configure this from the Report Server Web Portal using the following steps:
Open the Power BI Report Server Web Portal.
Navigate to the report that connects to PostgreSQL.
Select the ellipsis > Manage.
Go to the Data Sources tab.
Locate the PostgreSQL data source used by the report.
Under Connect using, select Stored credentials.
Enter the PostgreSQL read-only database username and password.
Click Apply to save the configuration.
After this configuration, the refresh will run using the stored PostgreSQL credentials instead of the Report Server service account.
This aligns with the documented behavior of Power BI Report Server, where reports connect to data sources using the credentials configured in the report’s data source settings rather than the interactive user context used in Power BI Desktop. Once configured, you can validate by triggering a manual refresh or confirming that the scheduled refresh runs successfully.
Hope this helps,
Thank you.
I have modified the web reports to use an account that has read-only permissions in the PostgreSQL DBs. It is the same account that was used to develop the reports in the Desktop app. All of the test connections are successful but when I try to refresh the reports after saving the modification, they do not refresh. No errors, no indicators of issues. Just doesn't appear to actually refresh. I refreshed the desktop app version to make sure and they all refresh and pull new data. For some odd reason, I was initially getting a pop-up when testing the connection that I needed to install Npgsql-4.0.10 or newer. I assumed this was already installed since Npgsql should be installed with the on-prem report server since June 2025. We're on September 2025. I installed it just in case and the pop-up went away. Where do I need to look in the logs or which specific log will tell me where the issue is?