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 - datafow and PBI Desktop - in both sources the same trouble. 

What`s wrong with my connection? 

 

Need Help

2 Replies

  • 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