Forum Discussion
Dashboards and row level security
Dashboard tiles preserve the filters at the time of pinning. So, if you pin a visual to a dashboard as a user that can see all of the data, that's what the dashboard will display. In your case, you would need to pin the visual to the dashboard WHILE you were that other user and then I believe it will work, but only for that role. You would need a separate dashboard for your other role. Pinning a "live" report tile might work, but then that is the entire report.
Thank you everyone for your answers. So what would you recommend I do if I want to share these charts in a dashboard using an app, but there's some sensitive information that should not be seen by certain users? As far as I'm aware you can only publish one app from a single app workspace, and the content of the app is the same for all users you grant permission to view it? So is the only solution to have two completely separate apps with only one of them containing the sensitive information?
Hi tusmo
I can confirm that when I am using RLS and creating a dashboard that the user will only see the data on the dashboard that is relevant to them.
This will also work in exactly the same manner if you deploy your reports and dashboards via the App experience. There be no need to create multiple apps, you can have all the users within the one App. And as they log in it will display their slice of data.
What I often do is find another user in the Organization who is allowed to view the data, and add them into the RLS to test with to ensure that it is working as expected. This also gives you some piece of mind that it is working.
I think you're receiving too high level of answers here. Lets start with enabling the Row Level security.
You do this from the "Datasets" section of the workspace.
Then select the roles for your row level security and add the individuals or groups you want to be able to access the information.
That will enable the row level security for the Role for the people selected and when one of the people you have enabled views it, it will only show them the information that the Role is allowed to see.
Hi tusmo,
I think dynamic RLS with username will suitable for your requirement, please refer to below link to know more about this:
Regards,
Xiaoxin Sheng
