PostgreSQL + powerbi desktop connection error

[转角遇见你]

Hi，

I'm trying to connect my PB desktop to a PostgreSQL DB but the following error is generated:

[amitchandak · Accepted solution]

@转角遇见你 , Please make sure all settings are done

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

Please confirm postgresql version. with version 16, we might need a configration file at server end.

[Anonymous · Accepted solution]

Hi @转角遇见你 ,

Please kindly refer to the similar post and try the possible solutions:

c# - Could not load file or assembly System.Runtime.CompilerServices.Unsafe - Stack Overflow

It contains the following two suggestions.

1.Register System.Runtime.CompilerServices.Unsafe version 4.0.4.1 into GAC

2.If you use Net Framework projects with xxx.config file, you could use bindingRedirect. Add these in app.config file or web.config file.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@转角遇见你 , Please make sure all settings are done

https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

Please confirm postgresql version. with version 16, we might need a configration file at server end.