Forum Discussion
Scheduled update with postgresql data source in google cloud
First, thank you for your response. To be more specific I tell you: right now my postgresql database is a dedicated resource in Google Cloud, so yes it is in cloud. What I am doing is with this database taking it as data source for my reports in power bi desktop. In this step I can connect it as a data source without problems. However, when I publish the report n epower bi service and try to schedule an update is where I have the problems. In the gateway part it tells me the following, i.e. that I do not need a gateway for this data source:
The problem comes when it asks me for the credentials of the data source
When I edit the credentials and add the user and password I get the error I indicated in the initial query: Data source credentials could not be updated: An error occurred while reading data from the supplier: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond'
Hi AndresEsteban ,
Here are some suggestions that I hope will help you.
1. Verify firewall and network settings. Ensure that the Google Cloud PostgreSQL database is configured to accept connections from the IP address of the Power BI service. You may need to adjust your firewall settings to allow these connections. More details can be found at the link: Configure public IP | Cloud SQL for PostgreSQL | Google Cloud.
2. If the connection is configured to use SSL, ensure that all required certificates are properly installed and configured in the PostgreSQL database and Power BI service. For more details, see the link: PostgreSQL: Documentation: 16: 19.9. Secure TCP/IP Connections with SSL.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous
First, thank you for your help. I have some doubts about your recommendations:
How do I know the IP used by Power BI Service so I can configure it in my database connection?
Thank you