Forum Discussion
Connecting to PostgreSQL server credential / certificate errors
- 1 year ago
Hi,
I've checked with the company that hosts the DB, according to them, the DB settings haven't been changed, so I have the feeling it has to do with PBI itself.
Meanwhile I have used another method to connect to the DB, rather than using the native PostgreSQL connector, I am using the connector 'ODBC'.
= Odbc.DataSource("database=[DB_name];driver={PostgreSQL Unicode(x64)};port=xxxxxx;server=[Domain or IP];sslmode=require;", [HierarchicalNavigation=true])
This took some additional work to re-configure our dashboards but it dit the trick. It isn't a solution to fix the PostgreSQL issue itself, but a good workaround for people encountering the same issues. Still curious how this PostgreSQL issue could be fixed though.
- Anonymous1 year ago
Hi all,
New version with fix has been published to download center Download Microsoft Power BI Desktop from Official Microsoft Download Center (version 2.137.1102.0). It will be updated/available in Microsoft Store in few hours.
Best Regards,
Gao
Community Support Team
Hi Anonymous ,
How do I connect using Npsql v4.0.10? I installed it using the .msi, but it still is not working unfortunately.
Hi Tjeerd ,
Try rolling back the PBI Desktop version and check if this solves the problem. You can find download links for previous versions of the desktop here.
Previous monthly updates to Power BI Desktop and the Power BI service
Best Regards,
Gao
Community Support Team