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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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