Parameter/filter reduced/related to the user's states

[klee]

I would like to have the main user data filter/parameter to be short listed/related to the selected user’s states.

Related data parameter

[duncan]

Hello @klee , welcome to the QuickSight community!

Have you checked out RLS?

Using row-level security (RLS) with user-based rules to restrict access to a...

[klee]

Does it work with the direct query for the dataset. Also, I am running into “DatasetRulesInvalidColType” or “Modify dataset rules to exclude these columns. Error code: DatasetRulesUnknownColumns”. I haven’t found a way to modify the rules other than a radiobuttons.

[duncan]

Hello @klee !

I would suggest checking out this solution for that error:

Row-level security error

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

I’m not 100% sure what the error is referring to in your dataset, but I would double check that all columns are spelled the exact same way between your datasets.
Using row-level security (RLS) with user-based rules to restrict access to a dataset - Amazon QuickSight.

[Xclipse]

Hi @klee. Checking in. We have not heard back from you regarding your question. We’d still like to help. We will archive this question. In case you need further assistance with your problem, please create a new post.