Set security in data Model

Summary:

Some users have access to the Data Model, and the customer needs to set security restrictions within the Data Model. For example, User X should only be able to see employees in Payroll 1 and should not have access to any data for employees in Payroll 2.

However, when User X creates any SQL query in the Data Model, the results include data from both Payroll 1 and Payroll 2.

I’ve reviewed the roles related to User X, and they all inherit security profiles, except for the BI Consumer and BI Author roles, which do not seem to enforce these security restrictions.