topic Postgre sql connector to PBI - empty tables in Developer

Postgre sql connector to PBI - empty tables

alexTaran — Fri, 29 Mar 2024 13:42:33 GMT

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?

Re: Posgre connector to PBI - empty tables

Anonymous — Fri, 29 Mar 2024 06:05:02 GMT

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

Re: Posgre connector to PBI - empty tables

alexTaran — Fri, 29 Mar 2024 08:40:14 GMT

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