Row Level Security question

Question & Answer
, ,
1

Hi everyone,
I have a question regarding Row-Level Security (RLS) in QuickSight.

The rule dataset works perfectly with my main dataset — smy_performance_overview. However, I encountered an error: “Failed to update user-based row-level security” when trying to apply the exact same rule dataset to another dataset, even though it has the same structure as smy_performance_overview(a ‘rls’ column added).

The rule dataset smy_rls_quicksight contains two columns: UserName and rls, and it works fine with the smy_performance_overview dataset as shown in the attached picture.

Could anyone please help me figure out what might be causing this issue?

  • It said that I could not upload more than 1 picture as a new user in my post so I will put the other one in the comment section.

image

2

Here is the error picture

image
image1884×893 70.1 KB

3

Hello @hung_doan , welcome to the QuickSight community!

Did you ensure that the fields your are using for RLS are string data types on your target dataset? I’m not confident this is the issue but its a good place to start.

4

Hi Duncan,

Thanks for your reply,

Yes, I did make sure they all share the ‘string’ data type. Wondering what went wrong :smiling_face_with_tear:

5

Hey @hung_doan

Are you still running into this or were you able to get it to work?

Assuming both of the columns from your rules dataset exist and match in your target dataset and you went through the normal process, I don’t see why this wouldn’t work.

You could try to do this programmatically. I’ve never done it this way but I think you should be able to use this:

If that also doesn’t work then I would recommend reaching out to AWS support.