topic Re: userprincipalname() returning Server Name in Report Server

userprincipalname() returning Server Name

magji — Thu, 01 Oct 2020 12:27:28 GMT

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.

Re: userprincipalname() returning Server Name

FarhanAhmed — Fri, 02 Oct 2020 04:44:32 GMT

Hi,

Can you please share the screenshot of the issue?

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

Re: userprincipalname() returning Server Name

magji — Fri, 02 Oct 2020 12:40:38 GMT

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.