Forum Discussion
Analitika
4 years agoPost Prodigy
Data source settings
Hello, I would like to know if I could connect to PostgreSQL or Sybase in Power BI. Some tables requires use sybase other use postgresql. So how to implement two ways logging in. I am having erro...
amitchandak
4 years agoSuper User
Analitika , for postgresql you need SSL , certificate etc. Have done all those steps. Check in second link there are steps, do not miss any
postgresql
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/
- Analitika4 years agoPost Prodigy
Hello,
Whenever I am trying to connect to postgresql, in invoked custom function I am getting DataSource.Error: PostgreSQL: 42601: syntax error at or near "["
Details:
DataSourceKind=PostgreSQL
DataSourcePath=200.144.044.43:0132;dbname
Message=42601: syntax error at or near "["
ErrorCode=-2147467259.How to resolve this issue?