Forum Discussion

Icon for Helper I rank

Helper I

6 years ago

SSAS Current User Blank

I created a Tabular cube in SSAS 2017. I have Row Level Security in the cube and it works great. I still need to be able to see who the logged in user is though to do some claculations. I have tried ...

Icon for Super User rank

Super User

6 years ago

Your user are coming from same verication system like active directory etc ?

KevinW_SDP
Helper I
6 years ago
Yes, it is using active directory and all users are in the same domain. The systems I am loggin onto are computers on the domain so they should be picking up the Windows user. This works when using SSMS, just not Power BI.
- v-yuta-msft
  Community Support
  6 years ago
  KevinW_SDP ,
  
  Have your sever AD been added as an admin of the cube instance? You can refer to the doc below:
  
  https://powerbi.microsoft.com/en-us/blog/how-authentication-with-analysis-services-live-connections-works/
  
  Community Support Team _ Jimmy Tao
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  - KevinW_SDP
    Helper I
    6 years ago
    Yes, it connects and the Dynamic Row Level Security works. I am able to log into a machine as different users and verify that I can see the data related only to that user.
    
    I have a service account set up that everything runs through. The service account is a domain account that is dedicated to this task and has the appropriate permissions as far as I can tell since the Row Level Security is working fine.
    
    The part that isn't working is me being able to use the following calculation as it just returns blank.
    Current User:=USERNAME()
    
    It seems to work in the row level security filter DAX, but doesn't display anything when using it in a calculation.

Related content