The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello fellow Power BI developers,
I have a challenge which I cannot find a suitable solution for.
We have a situation in which we woud like to restrict users to see the content of a specific column in a (dimension) table.
For example: The users can see all the information in the customer table, except for the customername. The users can only see the costumername for the customers they are responsible for.
So its basicly a combination of RLS with object level security.
I tried a lot of thinks but I cannot get it to work. I got it to work by making a measure, but having a measure instead of a label is not a suitable solution.
I am working with a SSAS Tabular model.
Any advice?
Regards
User | Count |
---|---|
25 | |
10 | |
8 | |
6 | |
5 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |