Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Is there a way where we can hide a particulay column data for some users and show the data to other users.
For example I have salary information, I dont want to show this to everyone. I would like to show only for few people based on their grade. How I can acheive this please?
I know how to do Row Level Security but not sure if there is a way to acheive column level security. If I do row level complete row will hide but I dont want to hide whole row, I just want to hide the column value. Any suggestions/ideas please?
Thank you.
Solved! Go to Solution.
Hi nivas258,
Power bi doesn't support column level security, to achieve your requirement, you may consider to apply column level security in ssas, please refer to this documentation: https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/object-level-security?view=sql... Then you can connect to that tabular model in power bi desktop.
Regards,
Jimmy Tao
Hi nivas258,
Power bi doesn't support column level security, to achieve your requirement, you may consider to apply column level security in ssas, please refer to this documentation: https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/object-level-security?view=sql... Then you can connect to that tabular model in power bi desktop.
Regards,
Jimmy Tao
Cant we just transpose the columns and then apply RLS??
You mean unpivot and apply RLS on this? I tried this but its not working.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |