Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Postgres Npgsql connection only shows tables and no views

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 

 

 

  • 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.

     

     

2 Replies

  • 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.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable

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