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
5 months ago

Hi tgg3 ,

Thank you for reaching out to Microsoft Community.

Although the report file is the same, the security context used during refresh is different between Desktop and Report Server.

In Power BI Desktop the connection runs under the interactive Windows identity of the logged-in user. The database authentication is performed using that user’s domain credentials. If the user has access to PostgreSQL, refresh succeeds.

In Power BI Report Server the refresh runs as a background (non-interactive) process. It executes under the Power BI Report Server service account, or the stored credentials configured in the report’s data source settings. It does not use the interactive desktop user identity.

The domain controller denying access strongly suggests that Windows based authentication (SSPI/Kerberos) is being used somewhere in the authentication chain.

 

To proceed, we need to confirm:

How the data source is configured on Report Server (Use current user, Windows Authentication, or Stored Credentials)?

What account the Report Server service is running under?

Whether PostgreSQL is configured for SSPI or username/password (md5) authentication?

 

Once confirmed, we can determine the correct remediation path (Kerberos configuration, service account permissions, or switching to stored database credentials).

Thank you
Chaithra E.

tgg3's avatar
tgg3
Helper I
5 months ago

V-echaithra, thank you so much for the insight. That makes a lot of sense. I will dig into this on Monday or Tuesday.