Row Level Security - user with double roles - Sales and Trade Manager

[Alle016905]

Hi

I have more reports with only one data model. In the data model I use RLS for Sales user, but some Sales user are also Trade Manager user that have to see all data by Trade (region area).

If I add new roles with filter in region and assign the same user that has already sales role, he can't see all data region but only data region where the seller is himself.

Do you idea how to solve it, maybe with DRLS?

Thanks.

[Greg_Deckler]

@Alle016905 - Yes, I would conjecture that you would need DRLS for this but it is tough to say given the current level of detail in your post. 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Hierarchical-Row-Level-Security/m-p/...

[Alle016905]

Example: every row of the database contain product sold, seller, market, branch and others details.

At the moment when the user login in PBI, by RLS rules and security on data set in power bi service, I can filter data by Sales name rule (security = login name). 

I'd like that the different report name 

Sales Report by Sales Name

Trade Report by Region

Branch Report by Branch

show different data even if a user login can run all 3 reports, because he is a Sales but also Trade Manger and\or Branch Manager

Is not clear for me how to implement DRLS

[v-jingzhang]

Hi @Alle016905 

Please refer to these blogs. They may help enlighten some new ideas.

Configuring "all" access with dynamic row-level security – XXL BI

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-...

Dynamic Row Level Security in Power BI with Organizational Hierarchy and Multiple Positions in Many-...

Regards,

Jing