We’re facing an issue with our QuickSight embedded dashboard where some users are unable to view data or filters, while others can see everything normally.
Error Message of the user:
PERMISSIONS_DATASET_USER_DENIED
You can’t access this data because it is restricted.
As a dataset owner I am getting this issue:
ROW_LEVEL_SECURITY_TIMEOUT_EXCEPTION - Getting the Row level security configuration for your dataset is too long.
The issue started recently before its working fine.
The RLS dataset query runs successfully in Aurora, with no invalid rows or long cells.
When trying replace the existing RLS dataset with a new one, the data source selection radio buttons are unresponsive QuickSight doesn’t allow selecting a source.
Troubleshooting Tried:
Created a new RLS dataset and tried reattaching it (UI not allowing source selection).
Detached and reattached RLS dataset multiple times.
Confirmed usernames match QuickSight identities exactly.
Verified RLS dataset query execution success.
Has anyone experienced similar behavior with Direct Query RLS datasets?
How complex is your RLS dataset? How long does the query take to run in Aurora?
The issue with using direct query for RLS is that it adds a delay to your dashboard. Your dashboard won’t load until QuickSight has finished running the query in your RLS dataset. If the RLS dataset is complex, it can add a significant delay. In your case, it sounds like the delay is so big that it causes the dashboard to time out.
It should work if you change your RLS dataset to SPICE. If you want to use direct query, see if there’s any way you can make the query run faster.
Thank you for your response. I have switched the RLS dataset direct query to SPICE, but I’m still getting the same issue. I waited for about 30 minutes and rechecked, but the problem persists. The query execution time is about 5-6 seconds.
The dashboard itself is working completely fine, but a few filters are not working
users are getting the error message I shared in previous message.
Only, few users can view the filters and dashboard without any issue, while others still face the problem.
No, it’s not the same error as the one you shared.
I’m an admin, and I’m getting the error shown in the screenshot below when accessing the analysis. Same error for users when the access the filter in dashboard.
What happens if you use the same RLS with a different (smaller) dataset? Create a small dataset and apply the same RLS to it. If that works, it will tell you that the issue isn’t with the RLS alone.
@David_Wong
Actually,I tried creating another RLS dataset and attempted to replace it with the old RLS dataset but the UI isn’t allowing me to select the data source to choose the new dataset. The selection radio buttons are unresponsive.
I can view the filters in the QuickSight dashboard without any issue, But in the analysis for one filter where I’m getting the “PERMISSIONS_DATASET_USER_DENIED” error. All other filters work fine for me.
However, for reader users, it’s completely different — they can see the filter that I cannot, but they’re unable to see the ones that are visible to me.
Following up here as it’s been a while since last communication took place on this thread; did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Since we haven’t received any further updates from you, I’ll treat this inquiry as complete for now. However, if you have any additional questions, please feel free to create a new post in the community and link this discussion for context.
