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,
I have three tables as shown below. I have some users who only are allowed to see numbers at the department store level and not the employee level. In my graphs I have drill down from department to employee and I wonder if it's possible to define this security with the RLS functionality. If DimEmployee is filtered then blank or something like that?
Solved! Go to Solution.
Hi norway84,
You requirement is to need a column level security, not the row level security, right? Currently, power bi don't support this feature, you can vote for this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15578172-column-level-security-fo....
In addtion, DAX expression in RLS is the conditional expression which can only be used to filter rows in other tables, not the result expression. For example, you can't use DAX formula function like isfilter().
As a workaround, I recommend you to use SSAS to define column level security, and then use live connection to connect to SSAS model in power bi. Reference.
Hope this can help.
Jimmy Tao
Hi norway84,
You requirement is to need a column level security, not the row level security, right? Currently, power bi don't support this feature, you can vote for this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15578172-column-level-security-fo....
In addtion, DAX expression in RLS is the conditional expression which can only be used to filter rows in other tables, not the result expression. For example, you can't use DAX formula function like isfilter().
As a workaround, I recommend you to use SSAS to define column level security, and then use live connection to connect to SSAS model in power bi. Reference.
Hope this can help.
Jimmy Tao
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |