David, the usual way we deal with that requirement in Tableau is through what is called a "user filter".
This involves, at a high level, joining a table of authorized users to your source data in such a way that each row contains the name of the user who is allowed to "see" that row, and then building your workbook to capture the logged in user in Tableau Server. You then compare the logged in user to the "authorization" column and return only the rows that match.
That is a VERY rough overview of how to do it, and it only works if you have Tableau Server (or Online). It sounds like that is true in your case.
Search for "user filter" in the forums for lots of examples.