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 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!!

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

2 Replies

  • 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