cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

2 REPLIES 2
Highlighted
Memorable Member
Memorable Member

Re: userprincipalname() returning Server Name

Hi,

 

Can you please share the screenshot of the issue?

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

 

FarhanAhmed_0-1601613826480.png

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Highlighted
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

Announcements
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.

secondImage

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!.