postgresql odbc driver error

[kevderbeste]

hi, i was trying to connect to postgresql database but i can't cause dont have certificatyes o some of this. My solution was install postgresql odce driver, I did the test connection and this was succesfully, i tried to connect from power bi and the connection was succesfully too. But after i changed the password for one encrypted and test connection again and was succesfully from dsn setup, and tried again from power bi and here appear an error saying that the password failed for this user. 

Any idea about this error ? 

[Greg_Deckler]

Go into Data Sources and edit the authentication or remove the data source and re-add it?

[kevderbeste]

Hi Greg thanks for the information, i had tried this, but is not work. 

[v-shex-msft · Accepted solution]

HI @kevderbeste,

Maybe you can take a look at following link about use power bi desktop to connect postgresql datasource:

Connecting Power BI To PostgreSQL

Regards,

Xiaoxin Sheng

[technolog]

@v-shex-msft @kevderbeste 

The link stopped working. I suggest a new link for this topic with a full description.

https://hevodata.com/learn/connect-postgresql-to-power-bi/