Forum Discussion

skpanugantibi's avatar
skpanugantibi
Advocate I
10 years ago
Solved

Cannot see PostgreSQL 9.5 Views in table browser

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 thr...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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's avatar
skpanugantibi
Advocate I
10 years ago

Thank you. It worked!!