Forum Discussion
PostgreSQL Reports Not Refreshing On Web Page
- 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 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 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
v-echaithra, This did not resolve the issue. I applied the January 2026 Report Server patch and had MECM deploy the desktop appliance. Doing that allowed me to login to the desktop appliance, refresh the reports, save them upon closing, and then the reports refreshed when opened in the website portal. If I attempt to refresh a report directly in the website portal it never refreshes. No obvious errors in the logs, no new information retrieved, it just goes off into space. Still successful test connections on the reports. I have attempted to setup scheduled refreshes but received an error. I'm not seeing in the logs what the error actually is. Where would you look to find what the issue is when setting up a scheduled refresh? Thank you in advance for any and all help.
- v-echaithra4 months agoCommunity Support
Hi tgg3 ,
Since the refresh works in Desktop but not in the web portal or via scheduled refresh, the issue is likely related to Report Server background execution rather than the data source itself.
To troubleshoot scheduled refresh failures, check the following:
1) SQL Server Agent > Jobs > Job History
2) ExecutionLog3 table in the ReportServer database to verify whether the refresh is triggered and its status.
SELECT
ItemPath, TimeStart, TimeEnd, Status, ByteCount, RowCount, AdditionalInfo
FROM ExecutionLog3
ORDER BY TimeStart DESC3) ReportServerService logs in PBIRS\LogFiles (search for the report name or any “ERROR” entries)
4) Windows Event Viewer (Application logs) for any underlying service-level issues
If no clear errors are found, try creating a simple test report using one table and one column from the same PostgreSQL source, then try refreshing it in the portal and via scheduled refresh, if it still fails, the issue is likely infrastructure-related; if it works, the problem is likely due to dataset or query complexity.
Hope this helps.- tgg34 months agoHelper I
v-echaithra thank you for responding. I will take a look at this tomorrow. Just to be clear, we do not currently have any scheduled refreshes in the web portal. We are trying to set one up for these reports that are not refreshing independantly of the desktop version. We can access the scheduled refresh setup in the web portal, but after customizing the frequency and attempting to save, it errors out.