Unable to refresh QuickSight Dataset
I inherited a QuickSight Dashboard, Analysis and Dataset from a colleague who is no longer with the organization. The dataset is based on a custom SQL pointing to a PostgreSQL database. I was granted ownership of the dataset. However, I am unable to refresh it because I receive the following error:
"You can't execute the custom SQL query because you don't have sufficient permissions to connect to the underlying data source."
I am perplexed, I do have access to the data source and it is a shared data source. What do I need to do to get the dataset to refresh?
Connect with your database by using other tool/jdbc etc. to figure out that with the same credentials you can access the data.
secondly verify that all the DB structures tables/view are in place again with this user you are making connection with DB.
Check your Region too.
Error in Visual: The dataset changed too much for QuickSight to automatically update your analysis. You can edit the fields or filters in the current dataset, or replace it with a different dataset.asked 2 months ago
Quicksight API for Refreshing a datasetasked 3 months ago
Multitenacy in quicksight embedded dashboard without session capacity pricingasked 2 months ago
Do we have to Spice duplicate data?Accepted Answerasked 3 days ago
Amazon QuickSight - is it possible to fully automate a dashboard creation with AWS SDKAccepted Answerasked 2 years ago
Unable to refresh QuickSight Datasetasked 3 months ago
Detecting data-share in Amazon QuicksightAccepted Answerasked 2 years ago
Is it possible to concatenate two datasets in AWS QuickSight?asked 3 months ago
Quicksight dataset SPICE refresh not loading dataasked 24 days ago
CDK QuickSight unable to schedule refreshasked 4 months ago