I set the schedule to import data to QuickSight spice every hour yet I got error message below.
Data in my account is controlled by LakeFormation so I granted the data access permission to QuickSight service role but still getting the error. How can I fix it?
“test_view” failed to refresh
A problem occurred during the refresh of your SPICE dataset for the account. Here are the details:
Access to the requested resources denied by the data source. Request permissions from your database administrator or ensure proper permission has been granted to Amazon QuickSight before retrying.