Error on Scheduled Refresh: Postgre DB Dataflow

[Anonymous]

Hi,

As the title implies, the scheduled refresh of the data flow which connects to Postgre DB performs inconsistently.

Sometimes, the error message goes away after the manual refresh, but I am not able to resolve it completely.

The below message is the error shown in the downloaded refresh history file.

PostgreSQL: 40001: canceling statement due to conflict with recovery.

Please share if there are any similar experiences/ know solutions. Thank you in advance!

[Anonymous · Accepted solution]

Hi @Anonymous ,

This issue has been submitted internally.(Internal ICM ID: 266454462)

Please be patient to wait for fixing. If there is any news, I will update it here.

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[HashamNiaz]

Hi @Anonymous !

It seems your Postgre DB is in recovery state. Please verify if the DB is online & then manually kick off the scheduled refresh from Power BI Service.

If the manual kick off completes successfully than monitor the next scheduled run.

Regards,

Hasham