Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

userprincipalname() returning Server Name

We have implemented row-level security in a dashboard.
The tables are working fine, but when we publish the dashboard in Report Server the row-level security does not work.

I created a measure just for testing User = userprincipalname() and I saw that the function does not return the user, but instead the Server Name. The function works fine when editing .pbix file.

Also the Row Revel Security in Manage is greyed out and I can not click.

Memorable Member
Memorable Member

Re: userprincipalname() returning Server Name



Can you please share the screenshot of the issue?

Also, make sure that you have roles created under Manage Roles




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Frequent Visitor

Re: userprincipalname() returning Server Name

@FarhanAhmed  Thank You for your answer.
I managed to fix the issue for the row level security by checking the tickbox Log in using these credentials, but then try to impersonate the user viewing the report in Manage -> Data sources the Report Server.

Now the function shows the user that is viewing the dashboard.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.