Row-level security error

Question & Answer
,
1

Hello
I Set up row-level security , Uploading CSV permission file by oneself, selecting it for apply dataset resulted error :
The dataset is missing column(s) specified in the dataset rules:
[login] Modify dataset rules to exclude these columns. Error code: DatasetRulesUnknownColumns
dataset rule : UserName login
oguanghm oguanghm
Any suggestions.
Thank You

2

Hi @oguanghm - Welcome to AWS QuickSight community and thanks for posting the question. Can you please share the csv file which is used for RLS and also share sample data as well.

Regards - Sanjeeb

4

Sample Data :
UserName login
abc abc
I need each user to only see their own login data. How do I need to operate it?
Many Thanks

5

Hi @oguanghm - Can you please share the sample data for your data set as well.

Regards - Sanjeeb

6

image
image2128×713 33.4 KB

This dataset is joined by two datasets (cn_hr_team,RLS_Permission)
and Dataset has null data

7

Hi @oguanghm - The RLS data set should be added on top of your data set… Please see the below documentation

Regards - Sanjeeb

8

@Sanjeeb2022 Thank you very much for your help

1 Like