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.
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.
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.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |