Forum Discussion
SSAS Live Connection - Filter for Current User
Anonymous that is how we are currently doing it? Using row level security at cube level which hide the rows from user depending on their role.
Thanks for the reply parry2k so do you have the scenario where a person can have multiple roles?
If they exist in multiple roles (eg Employee & Dept Manager) and those roles effectively have different filters (eg employee filtered for just the employee, & Dept Manager filtered for their DeptCode) does it not compound the filters and therefore if you browse the department manager report you're still just going to get the data filtered for that individual employee because the cube has applied both sets of filtering?
yes theoratically it will do that, basically whatever permsision you have on cube, it will get those permission or you need to use powerbi row level security
hmm i dont think that will work for us then in that case :(
Looks like we might have to pull the data from the DWH dim & fact tables into a model in the PBIX itself and then define an appropriate role in the report (eg if its the employee centric report to just filter for the current employee)
Anonymous,
Please check my reply in the following similar thread.
http://community.powerbi.com/t5/Integrations-with-Files-and/Row-Level-Security-in-Power-BI-multidimensional-SSAS/td-p/118908
Regards,
Lydia