Cannot see all tables when connecting to Postgres DB with Power BI

[yaronklein]

Hi,
I have a Postres DB hosted on AWS and this DB has 4 tables - 2 old ones that I already connect to and 2 new ones that I would like to add. I can access them when using DBeaver from my computer.
The new tables are in the same schema.

When I am connecting to the same DB using Power BI desktop, I can see only the 2 original ones.
I tired the following with no success:

• Open a new fresh Power BI report
• Clear all data source setting (File -> option and settings).

Any ideas what is going on and how to solve it?
Thank you!

[Anonymous]

Hi @yaronklein ,

You can open your pbix file then click Recent Sources to select your database, then click Refresh, check New Tables, then click LOAD.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[yaronklein · Accepted solution]

Hi Neeko,
Eventually it was a user access rights for the tables that I could see. Once we used a user that has access to them I was able to see them from Power BI desktop.
Thanks for your help!