Cannot see PostgreSQL 9.5 Views in table browser

[skpanugantibi]

I am able to connect to PostgreSQL (9.5) through Power BI Desktop but i can't see the "Views" which are defined in the DB other than tables.

And for MS SQL Server, i was able to see the Views through Power BI but not for PostgreSQL.

I have installed Npgsql 3.1.6 on my machine.

Any help on this would really be appreciated.

Thanks!!

[Anonymous · Accepted solution]

Hi @skpanugantibi,

Based on my test, I am able to see views of PostgreSQL database when connecting to PostgreSQL 9.5 from Power BI Desktop.

There are several proposals for you troubleshooting this issue.
1. Make sure you install the latest version of Ngpsql provider(3.1.7), and ensure that you are using the latest version of Power BI Desktop(2.37.4464.602).
2. Ensure that the account you used to connect to PostgreSQL database has read access to PostgreSQL views.


Thanks,
Lydia Zhang

[skpanugantibi]

Thank you. It worked!!