I am trying to have my dashboard automatically show data for logged in user

Q&A
,
1

Hi All,

I’m trying to set up a QuickSight dashboard so that each user automatically sees only their own data. I’m using ${USER_NAME} as the default value for a parameter and filtering on user_role_id, and RLS is also applied on the same field. However, the visuals aren’t showing the logged-in user’s data. Can someone advise the correct way to configure the parameter and filter for this scenario?I’m trying to set up a QuickSight dashboard so that each user automatically sees only their own data. I’m using ${USER_NAME} as the default value for a parameter and filtering on user_role_id, and RLS is also applied on the same field. However, the visuals aren’t showing the logged-in user’s data. Can someone advise the correct way to configure the parameter and filter for this scenario?

2

Hello Madhura,

I think the issue could be related with below. however, you would need to check in details

Parameter vs RLS Conflict

The main issue is likely that you’re trying to use both a parameter filter and RLS on the same field (user_role_id). This can create conflicts where:

  • RLS restricts data at the dataset level

  • Parameter filtering happens at the visual level

  • The two mechanisms may not work together as expected

RLS Dataset Requirements

Your RLS dataset must contain:

  • A UserName column with exact QuickSight usernames (case-sensitive)

  • A column matching your main dataset field name (user_role_id)

  • Proper mapping between users and their allowed data

Instead of using both parameter filtering and RLS on the same field, choose one approach:

Use RLS Only

  • Remove the parameter filter

  • Ensure your RLS dataset properly maps each user to their user_role_id

  • RLS will automatically filter data based on the logged-in use

Hope this helps.

Cheers,

Deep

3

However I want the manager who is logged in should already be selected in the control
How do I achieve this?

4

Hi @Madhura28,

If you apply RLS to your analysis/dashboard and setup based on the username, this should mirror once published; the user who is logged in will be used in the RLS and the results should show based on access for that designated user.

Let us know if you have any additional questions, if we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you