Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
zenisekd
Super User
Super User

Postgresql schedule refresh fails after credentials (password) change

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!

1 REPLY 1
v-xiaoyan-msft
Community Support
Community Support

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.

 

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors