Restricting report users from viewing certain location

Question

Hi,&nbsp;I have a power bi App that have figures for different locations, I would like make each operation manager to see only thier city data and restrict them from seeing the other locations, this is only for this App.The data source is a tabular model, I know I can use DAX to restrict users in the tabular model, but this will restrict them from the entire model.&nbsp;Can anyone help?

lbendlin · Answer

Anonymous&nbsp;wrote:Hi,&nbsp;I have a power bi App that have figures for different locations, I would like make each operation manager to see only thier city data and restrict them from seeing the other locations, this is only for this App.The data source is a tabular model, I know I can use DAX to restrict users in the tabular model, but this will restrict them from the entire model.&nbsp;Can anyone help?This sounds like you want to implement RLS. Did you have any trouble doing that?

anonymous · Answer

Can you do RLS when the data source is tabular model?

lbendlin · Answer

RLS is an internal function of Power BI (meaning both the roles and the rules for each role are defined in Power BI). It doesn't really care about the data source.

amitchandak · Answer

Anonymous , I think this case of RLS, Please refer 
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bihttps://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchieshttps://docs.microsoft.com/en-us/power-bi/service-admin-rlshttps://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/

anonymous · Answer

amitchandak&nbsp; thanks for your reply.&nbsp;I have been through those sites, most of them is related to models inside power bi I have AAS (Azure analysis seravices).&nbsp;But it did help me to think about it more and create below senario that might help to explain what I want, say I have :1. report A2. I want user1@sample.com to see only city1, user2@sample.com to see only city2 and user3@sample.com to see only city3 figures in report A3. I create groupReportA1,&nbsp;roupReportA2 and&nbsp;roupReportA3 Roles4. The row filter each of above roles will be assinged to the desired location in the tabular model location dimension5. Now i have report B6. I need user1@sample.com to see all cities7. I create groupReportB1 role and there will not filter for this user as we want this user to see all cites8. now user&nbsp;user1@sample.com is part 2 roles, one can see one city and in the other one the user1 can see all the cities.&nbsp;Does this work?

Forum Discussion

Restricting report users from viewing certain location

7 Replies

Related content

Restricted View Policy Bug

restrict viewing

Restrict viewing of Semantic Model

Viewing/Editing of SQL Views

Understanding Lineage View