Postgres Npgsql connection only shows tables and no views

[Anonymous]

Hi all,

We have a Postgres database running on AWS RDS. We've setup a gateway with Npgsql v4.0.10. The connection all works fine I can see all the data inside the tables. However, I cannot see the views that we've created in the Postgres database. 

Querying the database directly, with the same credentials used for the gateway, does show the views.

Any idea what else we can check to make this work? I'm sure it is possible, as I even see views in this documentation: Power Query PostgreSQL connector - Power Query | Microsoft Learn 

[Anonymous]

Thanks Ankit! It was indeed a lack of permissions on the postgres database for the user. 

[AnkitKukreja · Accepted solution]

Hi @Anonymous 

Probably you need to check if you have the correct perms on the DB. If views are not visible then it could be due to perms.