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 em...
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)