Forum Discussion

AndresEsteban's avatar
AndresEsteban
Helper I
2 years ago

Scheduled update with postgresql data source in google cloud

I have as data source a Postgresql DB that is hosted in Google Cloud. It lets me take the data source without problems but when I make a publication in power bi service and try to edit the data sourc...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

AndresEsteban's avatar
AndresEsteban
Helper I
2 years ago

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