I need some guidance as to how to accomplish a task at hand. I currently created a dashboard and published it to our Tableau Server using the SA Credentials. My question is how do we capture the username into a variable or parameter inside the tableau and send it into the sql datasource queries where clause. So when a user logs onto the server with their credentials, him or her would only see information pertaining to them in the dashboard. In our current scenario we have over 100 physicians assigned to different lines of business and different facilities so it's in our best interest to do it dynamically instead of manually. How does the row level Security in Tableau work, Can someone pls help.
there's a very nice written article on this very topic just published yesterday. Have a look: