Row-level Security to Multiple Reports with Same Dataset

You can implement different RLS for different reports based on one data set. The "trick" if trick it is, is to have more than one column, or, set of columns, which reflect the RLS you wish to implement for a given report. For example, you have 4 rows in your data, and you want to implement two different RLS. RLS 1 says one person can see all four rows, RLS2 says that 4 different people can only see their row.  So, you have two columns, one column has an ID for person who will want to see all four rows in all four rows, the other, has the ID of individuals who can see only that row. You can then make two reports, either the same or different to each other each using one of the two columns to govern RLS. An RLS can use more than one column to define who should see what (generally reflecting organisation hierachies), so, you could have two multi-column based schemes which can then be used to control access to whatever reports are based on the dataset.

An approach like this worked for me in the context of an organisation which has "Premium Workspaces" which gives everyone in the organisation domains the potential to see any report which can then be controlled by direct permissions (defining, restricting if necessary, the extent of the internal population who might potentially want or need to see the report, e.g. a departmental email group or the whole organisation) and then by RLS which restricts report access further according to whatever RLS rules you wish to impose.