Managing hierarchical organizations in Power BI security roles 

Thanks for reading my mind. I was just working on this today and then you release this video. Keep that third eye open!

Thank you Marco. This is extremely useful. Appreciate your efforts sharing you magnificent knowledge!

Thanks, Marco, I'm working on setting up a properly laid-out hierarchical table. I've been using PowerQuery to build the RLS table, which generates a large RLS table. Looking at doing it play around with your method

This really simplifies security roles! Would the performance be any different when transferring the selection of PermissionsExtended to Organization using TREATAS on the same relationship column in an RLS formula on Organization rather than the many-to-many relationship?

Very nice and useful 👍 Thank you!!

Hi sir I am using the same hierarchy method but at a region level. For example, my data has 5 levels of hierarchy (Continent-->Country--->State--->City--->District) and each user has permission for different hierarchy. I have used the same methodology and was able to reach the desired output table. But when I am trying to build the relationship, it shows a circular dependancy error. Any idea what am I doing wrong ?

Thank you Marco. Yet again another great and helpful video. I wonder if you could make a video on how to implement RLS for benchmarks where the logged user has access to his own data, but other entities should me masked while being able to compare against them. Thank you.

I am having one doubt but not related to this content, Using teatedas Dax I connected date table and fact table. When user want to drill fact table aggregation value it's not filter date table untill I drag & make active relationship in the model, Is any other alternative way there to achieve this ?

thank you Marco, Any idea why I am getting circular dependency error when trying to set up the relationship between the 'ManagerID' columns? What did I miss?

@marco, What's the logic behind building Permissions table?

could you please provide me this dataset for practice?

how do we manage this for dynamically, i mean maintaining this in a sharepoint spreadsheet and allowing the user to dynamically changing the access

thanks. I watched the whole video and genuinely understood nothing.