Forum Discussion
Effective Username not fitlering at row level?
I have a data model built on SQL 2014 using Tabualr SSAS with a row level fitler =(EmployeeData[Dept] = "042").
This fitler is assigned to a user from a trusted domain in the SSAS data model. When opening a report conencted to this tabular cube, he only sees departemtn data where the code equals 042, thus it is workign as expected.
However, when I wire up the data model to PowerBI using the Analysis Conenctor in PowerBI he sees all the data, it is not fitlered as expected. When running the SQL Profiler, I can see his effective username is passed as his email address, not his AD domain\username. I was under the impression that some kind of translation takes place so that this featue would work to enfroce role and row level permissions.
Any ideas what I am missing or how to troubleshoot this effectively?
1 Reply
- AnonymousNot applicable