Power BI Dynamic Row Level Security with Organizational Hierarchy

[@louwjhl7227]

Your videos are excellent!!

[@dianegustavo1861]

Such a smart solution, thanks!

[@RADACAD]

Thanks. Glad it was helpful!

[@gerritheijnekamp4718]

Nice video! What is your preferred way to get rid of those blanks in the hierarchy?

[@pedja2518]

Great content! Thank You!

[@RADACAD]

Glad you liked it!

[@jamesgo9986]

11:28 - how do you remove the blank values?

[@gracetucek5089]

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?

[@RADACAD]

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.

[@imasutosh]

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

[@RADACAD]

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

[@mattelliott2940]

@@RADACAD nice! this is just what i need, thanks!