Im struggling to connect to a RDS dataset. I have attempted to configure a VPC connection within Quicksight following all the documentation, this creates successfully, however I still cant get the get the option to input to Database instance ID.
" QuickSight doesn’t have permissions to access that database. Follow the instructions atManaging Amazon QuickSight Permissions to AWS Resources to grant QuickSight permissions to that Amazon database."
I have attempted to trouble shoot using the documentation following the guides for RDS in a non default vpc.
Is this a permissions issue linked to the execution role in the vpc connection? Or anything else I could be missing.
Any help would be kindly appreciated