Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Microsoft Employeewhy cant you use RLS? can you not set RLS on the composite model?
Because we would need column-level security. We do have row-level security set up. Basically, think of the data like this:
| Region | Volume | Profit |
| Region 1 | 11 | 12 |
| Region 2 | 21 | 22 |
We have RLS set up sp that a user can only see data from Region 1. But we also need to be able to say that within that region the user can only see the column Volume, but not the column Profit.
Its ok if we only expose the Volume column in the report they are allowed to see. But once we give everyone access to Analyze in Excel, they will be able to see all the columns (indeed, only for their region but also the columns they arent supposed to see).
Right?
- jeroenterheerdt
right, so this is not a question about RLS, but about OLS 🙂 we are still defining the exact interaction with OLS, so stay tuned for that.