PostGreSQL schedule refresh error on Power BI service

[DeepakJha23]

Hi PowerBI Community,

We are using PostGreSQL database on AWS for our dashboard. The refresh on Power BI Desktop is working absolutely fine but when we are setting up the Schedule Refresh on Power BI Service we are getting the below error : 

"Failed to update data source credentials: An error happened while reading data from the provider: 'An attempt was made to access a socket in a way forbidden by its access permissions"

@Greg_Deckler@amitchandak @edhans 

[SS1992]

Hi Any solution to this error? I am getting the same error.

[ake]

Hi, im having the same error since saturday 15th. 

Im using a gateway to conect to MySQL AWS. 

[v-yuaj-msft · Accepted solution]

Hi @DeepakJha23 ,

Based on your description, I think maybe something wrong in the PostGreSQL, like firewall or TCP/IP.

Here is similar solved case.

Solved: data source credendial update error - Microsoft Power BI Community

Or you can refer to the following link for troubleshooting.

Troubleshooting PostgreSQL Database Connection Issues | The Solarium (wordpress.com)

Hope that's what you were looking for.

Best Regards,

Yuna

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

[v-yuaj-msft]

Hi @DeepakJha23 ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Yuna

[edhans]

I've not used PostGRESQL, so cannot test this, but have you looked at the permissions? This page has more info on how to access. I'm assuming you have the on-prem gateway set up and have established a connection in the online gateway settings?

[DeepakJha23]

This is a PostGreSQL database in AWS cloud. We are trying to set up the direct refresh without any gateway.

Thanks,

Deepak

[edhans]

There is an overview here - they are using an ODBC connection vs the native PostGreSQL connector. AWS Platform Tutorials - Power BI to PostgreSQL Connection (wciconsulting.com)