Role creation issue

[Anonymous]

I have created two types of roles, one for product category from product master and region from customer master. But in service both roles are not working together for same user.

Please help.

[Syndicate_Admin]

Hello, @SonaSingh123

Based on their description, I think both roles can't really work together for the same user in the Power BI service. It appears as one of the limitations of Power BI RLS:

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can accomplish this by using table and DAX relationships. You can follow this document:

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

Best regards

Qin _Robert Team

If this post helps, consider Accepting it as the solution to help other members find it faster.

[Syndicate_Admin]

Hello, @SonaSingh123

Based on their description, I think both roles can't really work together for the same user in the Power BI service. It appears as one of the limitations of Power BI RLS:

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test dynamic row-level security, which can accomplish this by using table and DAX relationships. You can follow this document:

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

Best regards

Qin Community _Robert Team

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[v-robertq-msft]

Hi, @Anonymous 

According to your description, I think that both roles truly can not work together for the same user in the Power BI service. It’s listed as one of the limitations of Power BI RLS:

If you want to achieve the roles with organizational hierarchy in the Power BI RLS, you can try the Dynamic Row Level Security, which can achieve this using table relationships and DAX. You can follow this document:

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[StefanoGrimaldi]

first make a test report and put those filter you added to both report on a filter visual and check if they work as you spected the data would be filtered, check the tables relantionships between filters, dac - dimensional tables, 

if assinging 2 roles with diff filters isnt working normally its a data filtering that giving you a unexted result or a relantionship missing or bad setted. 

[selimovd]

Hello @Anonymous ,

I'm not totally sure if I understand the problem.

But you can assign multiple roles to a user in Power BI Service.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi