Hello all
I have a scenario were I have two users whose Data comes from different tables. When published in tableau server , user1 should'nt be able to see user2 data. I have done this using sites option in Tableau server, where I was using two Dashboards for two tables. But I was told that dashboard should be one and I should implement both tables in same dashboard. Then I used Row level security to do it where I have used one table with both users data. I could do it successfully. But eventually I have to used two tables. How can I do this using two tables where tables should be selected dynamically based on the user.
Thank you.
Hi Sai,
Have you tried filtering on data source?
From Create a User Filter and Secure it for Publishing : "Rather than maintain user filters and special permissions on each published workbook, you can filter a data source, and then publish the data source to make it available as a shared, one-to-many resource for anyone who uses that data."
First, create a calculated field that selects the correct user ( USERNAME() = "username" or something like that).
Then, add this calculated field to the data source filters. In the upper right corner of the data source page, click Add:
Add the calculated field you created as dynamic filter.
Hope this helps!
Kind regards,
Wim
