Forum Discussion
Data source setting / Permissions / Can't authenticate with the credentials provided
Super UserAnonymous , there are three 4 steps that are mentioned here to connect to PostgreSQL. Please make sure you have tried those
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/
https://niftit.com/connecting-power-bi-to-postgresql/
But all this connectors problem should be already working just in PBI,
anyways, I resolved my issue with VM access,
Tony_KuiperHelper I
I have the credentials issues too. Cannot seem to resolve. Using a VPN to ensure I'm inside the security group, I can see the tables in pg4admin, but cannot get powerbi to connect....
When you work in PBI do you work on your local machine or VM? Looks like no one is talking about this but most likely depends on security rules on DB, ask for VM access and try from there
- Tony_Kuiper
I'm using local machine however I have a VPN. Also I can add the credentials to the postgre driver in windows, then I can get the tables in MS Access without repeating them there... So the tables can be accessed by numerous method EXCEPT Power Bi (which has a built in connector for just this). Frustrating.