Forum Discussion

kalwabharath44's avatar
kalwabharath44
Frequent Visitor
5 years ago

Hierarchy Row Level security with cascading functionality

Hi All, I have a report which requires Hierarchy Row Level security with cascading functionality L1 - Director L2 - Manager L3 - Supervisor L4 - Regular user When an L1 loges in then he nee...
Data Protection
Tips and Tricks
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

That depends a lot on the Excel file. Do you have a PowerPivot model or do you "only" have the data in tables? How would you provide the Excel file to your users? What are your data sources?

 

For example if you do a live connection to an SSAS Tabular with PowerPivot in Excel the security from the SSAS works perfectly fine. If you do a direct query connection to a relational database also the security on the database works.

So it really depends.

kalwabharath44's avatar
kalwabharath44
Frequent Visitor
5 years ago

Thankyou for the Response Denis. The data is in excel file as a regular sheet and i am pulling that into PowerBI.

Example or online sources have examples where ther are building the heirarchy but whereas i have the data as shown below.

User Email > Supervisor Email > L1 Email > L2 Email > L3 Email > L4 Email

How do i build dynamic row level security based on the data i have.