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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
talha_ts
Frequent Visitor

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

Hi,

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.

 

 

Thanks

 

 

 

6 REPLIES 6
gaurav_singh
New Member

Facing similar problem did you find some workaround ?

alexa_0028
Resolver II
Resolver II

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

 

Greg_Deckler
Super User
Super User

You could put the columns in a separate table.


Follow on LinkedIn
@ 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.

 

Thanks

 

Did you get a solution for this?

@talha_ts,

 

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

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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