Postgresql schedule refresh fails after credentials (password) change

[zenisekd]

Hi all,

2 weeks ago we changed credentials (password) on 4 database credentials of 4 different customers and since that all of them are having errors, about 80% of time when trying to initiate scheduled refresh or requested refresh. On the desktop, the refresh works fine. 

We are running Postgresql on AWS (not using RDS).  

I tried to talk to the support and created a ticket, but all they could come up with was to try to refresh it via gateway, which was failing as well, and learning that it is a known issue, which they are working on ... I guess for a while now.

The best results from searching online was here, but deleting the global permissions and reuploading didnt help. 

https://community.powerbi.com/t5/Report-Server/SCHEDULED-REFRESH-ERROR/m-p/508373

The error messages I receive are: 

Chyba zpracování:	PostgreSQL: Exception while reading from stream
URI clusteru:	WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
ID aktivity:	eca1bda5-9265-427e-bad2-424ba9d5b2ee
ID žádosti:	6993b775-4dc9-70e8-42ee-2920ca63ce8a
Čas:	2021-09-22 07:38:23Z

Chyba zpracování:	PostgreSQL: 40001: canceling statement due to conflict with recovery
URI clusteru:	WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
ID aktivity:	1dcc1205-c505-4cc2-b489-23733bc75c97
ID žádosti:	acc49fb0-ad8a-4bd4-a15e-e2709410ab1e
Čas:	2021-09-09 23:10:46Z

Any suggestions? thanks!

[v-xiaoyan-msft]

Hi @zenisekd ,

According to the error message you provided, here are some related solutions, please check if they are helpful to you.

Postgresql: Exception while reading from stream 

How to Fix PostgreSQL Error: canceling statement due to conflict with recovery 

Also, after resetting the data source password, did you update your data source credentials again at the gateway data source configuration? If refresh fails, check the dataset settings. If the gateway service is offline, Status is where you see the error. If Power BI can't sign into the data sources, you see an error in Data Source Credentials.

Hope it helps,

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.