SSAS Current User Blank

Question

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 the following measures:

Current User:=USERNAME()

Current User:=USERPRINCIPALNAME()

If I browse the cube using Management Studio, I see values. However, if I browse the cube using Power BI Desktop, the measure is blank. I published the report to a Power BI Reporting server to see if that would help and the measure is still blank.

Any thoughts?

amitchandak · Answer

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

kevinw_sdp · Answer

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 · Answer

KevinW_SDP&nbsp;,
&nbsp;
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/
&nbsp;
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 · Answer

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.&nbsp;&nbsp;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.&nbsp;The part that isn't working is me being able to use the following calculation as it just returns blank.Current User:=USERNAME()&nbsp;It seems to work in the row level security filter DAX, but doesn't display anything when using it in a calculation.

v-yuta-msft · Answer

KevinW_SDP&nbsp;,
&nbsp;
Both username() and userprincipalname() works well on my side. Will return the domain name in a calculate column on my side so I'm afraid I could not reproduce this issue. I would suggest you create a support ticket here for further analysis.
&nbsp;
Regards,
Jimmy Tao

Forum Discussion

SSAS Current User Blank

6 Replies

Related content

Blank Page - Embedded Report

Replace Values Null to Blank or Blank to Null

Counting Non-Blank Records

SSAS in Fabric

Hide blank member SSAS does not work in Power BI