Hey there, I recently got a request from some people here to implement another level of RLS for a couple of tabular models that I manage.
Background: I work for a commercial real estate company, so the security that I have implemented is based on region. Someone in Toronto can only view data from Toronto. Someone from Vancouver can only view data from Vancouver. And so on. Basically I used this guide: https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular
However, a request came in that for Calgary specifically, we should also implement security based on Property Type (Industrial or Office type). So now there should be 2 levels.
- Is the person viewing the data in Calgary? If yes, then what Property Type are they associated with? Display the data for their respective property type.
- If they are not in Calgary, then proceed as before.
I'm trying to figure out a simple way of doing this. I'm thinking of creating another column that concatenates Region+Property Type ONLY IF Region = Calgary; otherwise just use Region.
Any advice would be greatly appreciated. I hope what I wrote out makes sense, and if I need to clarify anything, please let me know.
- This topic was modified 2 weeks, 2 days ago by peterg417.