Forum Discussion
PostgreSQL data provider problem
Hello,
I am trying to connect to the posgresql database. I have installed npsql 4.0.10 as it was recommended in the PowerBI docs. It does not work. How can I get the access to the posgresql database ?
Hi Anonymous ,
Based on this error message screenshot, it appears that this issue is caused by the certification problem on the server. You can refer to the solution in the threads below to try to solve your problem.
PostgreSQL + powerbi desktop connection error
The remote certificate is invalid according to the validation procedure - Connecting Postgres
Client Certificates
If the above solution does not solve your problem, you can use ODBC connector to connect to PostgreSQL as an alternative solution. You can see the details of the steps in the links below.Connecting Power BI to Postgre SQL Database
Best Regards
2 Replies
Hi Anonymous ,
Based on this error message screenshot, it appears that this issue is caused by the certification problem on the server. You can refer to the solution in the threads below to try to solve your problem.
PostgreSQL + powerbi desktop connection error
The remote certificate is invalid according to the validation procedure - Connecting Postgres
Client Certificates
If the above solution does not solve your problem, you can use ODBC connector to connect to PostgreSQL as an alternative solution. You can see the details of the steps in the links below.Connecting Power BI to Postgre SQL Database
Best Regards
i have the same probleme can u help me please to solve it ?
in fact in the desktop i visualise the data with no problemes and it exchange with the data base postgreSQL normaly but one i publish it in the siteweb i cant visualise any thing sayin to me that this error :
Erreur sous-jacente: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: QueryUserError
QueryUserError: DataSource.Error: An error happened while reading data from the provider: '[ccon]The remote certificate is invalid according to the validation procedure.'. DataSourceKind = PostgreSQL. DataSourcePath = hutchinson.ineo-sense.com;ICM. [/ccon]. L'exception a été déclenchée par l'interface IDbCommand.
ID de corrélation: 8267c764-5d00-8cae-5a92-c807aab21ac1
ID d'activité: 9c2ff7f3-e846-47b3-960e-1752b6e6bac4
ID de demande: d6b88234-835d-9ee8-84f5-0af04b100662
Heure: Tue Mar 07 2023 22:22:49 GMT+0100 (heure normale d’Europe centrale)
Version du service: 13.0.20195.63
Version du client: 2302.4.12605-train
URI du cluster: https://wabi-west-europe-b-primary-redirect.analysis.windows.net/any help pleaaaaaaaaaase