Showing results for 
Search instead for 
Did you mean: 
Memorable Member
Memorable Member

Please Make USERNAME() function work in Service

Sign in still does not work for me in the Feature Requests or Help Topics sections as has been already reported here before, therefore, I have to other option but to post this feature request here.


I love Analysis Services, but very often it simply is not an option for many companies given where they are in their budgetary cycles, their technology landscape or many other technical and/or political reasons. However, many of them will still need a way to secure data somehow.


I am sure this is not an easy task, but if we could have USERNAME() function work right in the Service we would have at least some sort of a way to implement some level of security even with lots caveats and limitations.


This is not a sexy solution but I am really worried that having SSAS as the only option for security moving forward may impede the adoption of the product.

Memorable Member
Memorable Member

+ 1 totally agree..


Also could work in PowerBI Desktop ( username () ) and an option like SSDT to apply the filters in tables. 

Any of both options ( service or PBI desctop ) would be awesome and really exlode adoption.


Hope we have an answer from the PowerBI Team if is feasible and if they are thinking about offering it..


Konstantinos Ioannou

No answer from MS yet...


Username() may not be the best way to go about it but I can't help but think that SSAS should not be the only answer to security.

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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