Exactly what I was looking for. Thanks for the great video. But I have a question: If Mark accesses the report, will he only see the structure Mark + Bill? Or will he see Leila + Mark + Bill?
Do you still have to assign each user who has access to the reports to the role in powerbi web? Otherwise, user principle role won't be applied to them and the reports will be blank. Is there anyway to automate this role application online?
You will need to share the report with all users, and you need to add all users to the single role in the security. but all users can be added to an O365 group and that can be assigned there, so that the next someone joins the organization you don't have to go and add them one by one.
I have a situation where some employees have 2+ managers who are at the same level but from different teams. Please explain how to design the users sheet this scenario
I have explained such case in here: radacad.com/dynamic-row-level-security-in-power-bi-with-organizational-hierarchy-and-multiple-positions-in-many-to-many-relationship-part-1
Amazing video, thanks for sharing
😊👊
Your videos are excellent!!
Thank you! Glad you enjoyed it.
Exactly what I was looking for. Thanks for the great video. But I have a question: If Mark accesses the report, will he only see the structure Mark + Bill? Or will he see Leila + Mark + Bill?
Nice video! What is your preferred way to get rid of those blanks in the hierarchy?
Such a smart solution, thanks!
Thanks. Glad it was helpful!
Great content!
Thank You!
Glad you liked it!
Do you still have to assign each user who has access to the reports to the role in powerbi web? Otherwise, user principle role won't be applied to them and the reports will be blank. Is there anyway to automate this role application online?
You will need to share the report with all users, and you need to add all users to the single role in the security. but all users can be added to an O365 group and that can be assigned there, so that the next someone joins the organization you don't have to go and add them one by one.
11:28 - how do you remove the blank values?
I have a situation where some employees have 2+ managers who are at the same level but from different teams. Please explain how to design the users sheet this scenario
I have explained such case in here: radacad.com/dynamic-row-level-security-in-power-bi-with-organizational-hierarchy-and-multiple-positions-in-many-to-many-relationship-part-1
@@RADACAD nice! this is just what i need, thanks!