We have salary reports that burst out to users based on a table created from an excel cost centre to user worksheet Finance manage.
If a user opens this report in BI separately, then saves as a different name, the filtered salary specific to their cost centres is now available to all other users who had access to the saved area.
We want to prevent this random saving of sensitive data and make the users have to run the report based on the security table each time. How can we do this?
You could import the security table into your FM model. Then create relationships back to the table based on those. Or create row level security so that the users themselves can not see data that they should not have access to. Regardless, it sounds like an FM issue.