Forum Discussion

alexTaran's avatar
alexTaran
Frequent Visitor
2 years ago

Postgre sql connector to PBI - empty tables

Hi, guys,    I have connected to postgre DB but there are no data (empty tables). PGadmin shows that everthing is ok, db consist of 25 tables.  I did not use encrypted connection for both - datafo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi alexTaran ,

It seems like that there is no data in the tables when you connect to Postgre SQL. Could you please check the following info for the further troubleshooting?

1. Click the part with the red circle in the below screenshot and check if there will be some info displayed under it

2. Please make sure that you selected the correct database

3. Pease check that the credentials you are using to connect to the Postgre database are correct. Make sure that the username and password are correct and that you have the necessary permissions to access the tables

4. Please check if there is any data for those tables in underlying data source Postgre SQL

Best Regards

  • alexTaran's avatar
    alexTaran
    Frequent Visitor
    2 years ago

    Hi! thanks for the answer. 

    1) Sure I did it 🙂 see picture below

    2) correct. 

    3) credentials and access are ok (i `am a superuser/globaladmin on that pc where DB located)

    4) yes, those tables are not empty