Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Just as an example. I have a customer dimension
Name Address DOB Type
Fran Holmes 29 Road UK 11/11/85 Green
Ron Guest 30 Road UK 12/10/65 Red
Sophie Throp 30 Road UK 01/08/73 Amber
User 1 is allowed to see all the values
User 2 Is only allowed to see Name and Type
What is the best way of dealing with this issue because its not using the usual Row Level Security?
Hi @DebbieE ,
Reference: Row, Column and Table Level Security in Power BI
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is there any chance that this will get addressed because this is the top thing people seem to ask for?
Hello @DebbieE @vanessafvg
As per my experience, we can create a role in a way that we are allowing the required columns to be shown to the desired person as shown in the below image by making the value of the column as false
IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!
Im not following this. The value of the column is the actual value in each instance, e.g. 11/11/85 so I cant set the value to false. I dont think this would work for the above issue.
how will you identify which users can't see the column? You can use that condition maybe to set those columns to blank if that condition is met with a calculated column or measures, ... that could be tricky performance wise if a column.
what security is it using?
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.