Forum Discussion

tgg3's avatar
tgg3
Helper I
5 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
4 months ago

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 DESC

3) 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.

tgg3's avatar
tgg3
Helper I
4 months ago

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.