Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
roelof_cls
Regular Visitor

Manage Roles cant use USERNAME() Function

Desktop Version : Version: 2.123.742.0 64-bit (November 2023)

 

For some odd reason, the new Manage Roles cant make use of the function USERNAME() or USERPRINCIPALNAME()

 

When I want to use RLS to filter out Company from a UserCompanyPermission list I would normally state the Email = USERNAME()

 

roelof_cls_0-1709648971108.png

 

But when I look at the DAX Editor it sees my rule as [Email ] == "USERNAME()"

 

roelof_cls_1-1709649031949.png

 

Is this fixed in the latest version of PowerBI?

2 ACCEPTED SOLUTIONS

So I did remove and save it and it seems to work now.

 

But I can switch back to Default Editor. I need to remain on DAX Editor.

 

Hopefully they fix it so that the Default Editor (which seems way easier to use) can reference DAX Functions.

View solution in original post

On my desktop I'm using this 

_AAndrade_0-1709650222406.png

 And it's working fine without any error...





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




View solution in original post

3 REPLIES 3
_AAndrade
Super User
Super User

Remove the double quotes ("")





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




So I did remove and save it and it seems to work now.

 

But I can switch back to Default Editor. I need to remain on DAX Editor.

 

Hopefully they fix it so that the Default Editor (which seems way easier to use) can reference DAX Functions.

On my desktop I'm using this 

_AAndrade_0-1709650222406.png

 And it's working fine without any error...





Did I answer your question? Mark my post as a solution! Kudos are welcome.

Proud to be a Super User!




Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.