Forum Discussion
tessahurr
Microsoft Employee
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services. To learn more about this feature, please visit this blog post or our documentation. ...
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?
jeroenterheerdtMicrosoft Employee
Microsoft Employeeright, 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.