Hi @gaynorg !
You get this error when Quicksight cannot connect to the RDS datasource. There are a couple reasons that this could happen.
If it’s a Postgres version 14 or higher, see here.
To set up the connection with a private VPC see here . A common error with this setup is to NOT have both Security Groups in the VPC connection. You need both security groups.
If you still cannot connect after working through these docs, I would recommend filing a case with AWS Support where we can dive into the details to help you further. Here are the steps to open a support case.
Hope that helps.
ws