Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Dear Community!
Has anyone ever got this message while trying to connect to a Postgre DB? What was the workaround?
Thanks in advance!
Will
Solved! Go to Solution.
Hello Community!
That was definelty some firewalls dropping packages between the server I have the client installed and the database. I asked firewall team to open the route between source and destination and It worked properly.
Thanks for your insights!
Go to Edit Queries->Advanced Editor-> add timeout in the connection
Source = PostgreSQL.Database("server_name", "database_name", [CommandTimeout=#duration(5, 0, 0, 0)]),
This error may happen when connection string is lacking port number. Try using server:port in connection string to Postgres database.
How to do that?
I have the same problem. I can't connect Postgres DB to Power BI 😥
Hi @willianmsantos,
I'd like to suggest you setting the 'Timeout' parameters and try again, it may fix the issue.
Reference link:
Regards,
Xiaoxin Sheng
Hello Community!
That was definelty some firewalls dropping packages between the server I have the client installed and the database. I asked firewall team to open the route between source and destination and It worked properly.
Thanks for your insights!
how to "open the route between source and destination"? could you please give me some details? thanks
Bad news. This may well be the first of many errors you'll get trying to connect to a Postgresql data source.
I've been banging my head against a Certificate error for a week.
That's sad, I've spent most of day yesterday struggling over this issue. I hope to get back with some good news. 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |