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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

Change value of a column based on the role applied via RLS


I am using power bi embedded and using RLS to restrict the users viewing some rows once they are logged in.


There are some columns in my dataset which i would like to hide for some of the users who are not logged in.


I am passing a role for that case too using RLS but cannot use the measure/column to use the username and create a DAX column to show the dynamic data as it is not allowed to use customdata or username in a column. Is there any other way to achieve this? maybe change a value of the column if a certain role is selected using RLS.







New Member

Facing similar problem did you find some workaround ?

Resolver II
Resolver II

Hi, did you find answer? I am looking for something similar 
Please help me


Super User
Super User

You could put the columns in a separate table.

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Putting them in a separate column is not the solution to this because i want to put in a condition for calculated column or change the value of that column if the user has got access to it or not. 


Like showing ****** for users who dont have access and showing the value for the logged in users who have access.


the calculated column is not letting my apply the username condition neither directly nor via a measure.


hope I have explained it better now.




Did you get a solution for this?



You may leave a comment and vote this idea up.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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