topic Empty table after connection between postgres database and Power Bi has been made in Developer

Empty table after connection between postgres database and Power Bi has been made

Anonymous — Mon, 13 Jul 2020 15:07:22 GMT

Hi,

After I made a connection between the Postgres database with the postgres connector, I see no tables in it (while the connection is established)?

To start a connection, I entered the servername, the databasename and logged in with my credentials (this are the administrator credentials). Somehow I see no tables with data, while there are tables and data in the database.

I've already checked the settings for data sources for permissions, but al permissions are given. Does anyone have an idea how to solve this problem?

Re: Empty table after connection between postgres database and Power Bi has been made

Anonymous — Tue, 14 Jul 2020 06:57:31 GMT

Hi @Anonymous,

Does any specific setting apply to your data tables? Can you connect to your data source with other applications or other devices? I'd like to suggest you check your firewall rules and policy setting to confirm if any setting has blocked the requests.

Regards,

Xiaoxin Sheng

Re: Empty table after connection between postgres database and Power Bi has been made

Anonymous — Tue, 14 Jul 2020 08:19:29 GMT

Hi @Anonymous, I solved the problem. Afterwards it was a pretty small thing. I got the wrong database name. However, thanks for your help!

Re: Empty table after connection between postgres database and Power Bi has been made

alexTaran — Thu, 28 Mar 2024 11:14:38 GMT

Hi, the same trouble both for dataflow and pbi desktop.

What was wrong in your case?

In my case I have connected to postgre DB (used not ecrypted connection) but there are no data. PGadmin showsa taht everthing is ok, db consist of 25 tables.