Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!
Solved! Go to 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
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
Thank you. It worked!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |