I have a dataset in QuickSight where I have implemented Column-Level Security (CLS) so that certain columns are only visible to specific users. For example, columns A and B are visible to all users, but column C is restricted to user123 only. I have a table visual that displays data from this dataset, specifically columns A, B, and C. When user123 logs in, they can see the table without any issues. However, when any other user logs in, they get a message stating they cannot see the visual. I expected them to be able to see the table but only with columns A and B, since those are the ones they have access to. How can I achieve this?
Thanks
Hi @edcaso,
Good to see you back in the community! This is actually expected behavior in QuickSight. The key distinction is where the restricted column is placed in the visual:
- If column C is in the Values field well → other users can still see the table, but column C will show as “Not Authorized”
- If column C is in the Rows, Columns, or Group By field well → the entire visual is blocked for users who don’t have access
Since you want other users to see the table with only columns A and B, the fix is to create two separate visuals:
1. One table with columns A, B, and C. This is visible to user123.
2. One table with only columns A and B. This is visible to all other users.
You can then use sheet-level permissions or calculated visibility to control which visual each user sees.
For more details, here is the official AWS documentation:
Hope this helps!
Hi @edcaso,
Just checking back in since this thread hasn’t received a response in a while. Was Cesar’s reply helpful to you and/or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!
Thanks!
Hi @edcaso,
Since we haven’t received any further updates from you, I’ll treat this inquiry as complete at this time. Please feel free to create a new post if you have more questions.
Thank you.