Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
Anonymous
Not applicable

Role creation issue

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.

25 REPLIES 25
Syndicate_Admin
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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
Administrator
Administrator

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:

v-robertq-msft_0-1617701136372.png

If you want to achieve organizational hierarchy roles in Power BI RLS, you can test row-level dynamic security, which you can achieve 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.

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.