Forum Discussion
SSAS Live Connection - Filter for Current User
Hi
Hoping for a bity of advice, we've got an on prem SSAS MDX Cube that were looking at producing some Power BI reports against using Live Connection.
One requirement is that we produce an employee specific report/dashboard where the data will be filtered for the currently logged in user viewing the report. I don't seem to be able to find a way to do this using a live connection, is my understanding correct that this isn't possible in Power Bi by providing a suitable filter?
I realise we can implement Row Level Security RLS on the cube itself but the problem is that workers may perform multiple roles in the company so they might want to look at their specific performance report where the report is tailored/filtered to them as an individual, or if they are also a team leader/dept manager they will want to view a different report where its filtered based on their team or dept and therefore different filters would need applying.
Is the only way to do it to use different roles and perspectives directly defined in the cube itself?
Thanks
6 Replies
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
