Forum Discussion

CyrusOC's avatar
CyrusOC
Icon for Advocate I rankAdvocate I
10 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    CyrusOC There are a lot of variables here. I would first suggest you troubleshoot against this support page. It should at least narrow things down for you, and give anyone here a bit more info on what you've tried in pursuing resolution.