You can implement row level security in tableau to solve your issue.
- Restrict Data Access with User Filters and Row Level Security
- Row level security with ADhttps://onlinehelp.tableau.com/current/pro/desktop/en-us/publish_userfilters.html
- Auto refresh data on Tableau desktop
hope it helps.
We are using a table to restrict assess to our dealers via join in the data source using the username() function
I have the same question.
refresh=yes does not work when user browse the workbook through normal navigation from Tableau Server web UI.
Although I think it can be solved by a tailor-made extension, our company does not allow extension. Maybe you can have a try?