Forum Discussion
SSAS Live Connection - Filter for Current User
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
Anonymous tbh I'm not sure how that helps my sceanrio
let say you have 2 roles defined on the cube
1 Employee - where all data is filtered belonging a single employee via the employee Dimension (ie the person logged in)
2 Department Manager - where data is filtered by by it beloning to a particular department
I we have a user who is in both roles then the cube is going to allow them to see all their transactions and all transactions belonging to anyone in that department.
Therefore if they if they look at the report geared towards an individuals perfomances its going to returen datat belonging to all people in that department becasue there doen't appear to be anyway to dynamically filter it for just that users.
When they want to look at the department level perfmnce report yes they would want to see all the data broken down by different employees.
Using a LIve connection there just doesnt seem to be any way to dynamically filter that one persons data if they are allowed to see more than tat in the cube. If i've mis understood please could you procide an example of how it would work.
regards