Forum Discussion

fabiomanniti's avatar
fabiomanniti
Helper III
4 years ago
Solved

Import data from PostgreSQL

Hello, I have my Data on a remote PostreSQL and I'm trying to get them but with no success. I've tried two ways: 1. GET DATA -> PostgreSQL Database  Server: 34.xx.xxx.xxx Database: myDb Then I ...
Need Help
  • fabiomanniti's avatar
    fabiomanniti
    4 years ago

     I solved this using ODBC

    I had to create a ODBC Connector but I also had to enable SSL.

    The best way is throug ODBC Administrator (search on windows) so you can make a test to the connection. Otherwise the script is

     

    database=xxxx;driver={PostgreSQL Unicode(x64)};port=5432;server=34.xxxxxx;sslmode=require;

     

    This worked for me

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi fabiomanniti 

Is your database in the cloud ? If your database is on the cloud, you must also configure remote connections. You must do this by editing the pga_hba.conf file and the postgresql.conf file.

I searched a document about how to connect to Power BI from PostgreSQL , you can refer to it .

https://hevodata.com/learn/connect-postgresql-to-power-bi/

 

Best Regard

Community Support Team _ Ailsa Tao

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

fabiomanniti's avatar
fabiomanniti
Helper III
4 years ago

Anonymous 

Thank you but since I don't have access to those files (I'm not the one who manage the Database) I wanted to ask for a doubt:

I tried to connect this database both on Tableau and Datagrip and I didn't have any problem of connection; so, can it be possible that configuration files have nothing to do with this?