Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Thanks Ankit! It was indeed a lack of permissions on the postgres database for the user.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
18 | |
18 | |
9 |