Forum Discussion
Helper IICannot see all tables when connecting to Postgres DB with Power BI
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!
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!
2 Replies
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.
yaronkleinHi 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!
