Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I have implemented Row Level Security (RLS) in my model and cant figure out how to achieve partail filteration, let me explain:
My data model collects data from different farmers, each has diffrent ID (Field named "MR")
All the visuals in this report presents the same measure with diffrent filter context.
The data in visuals 3,4 shows the measure diced by Employye and month
The data in Visual 2 shows the value for all the rows inside the selected farmer ("MR")
the data in Visual 1 shows the value for all rows in model.
Each farmer is defined as role in RLS so he can see only his own data
I want that to apply to visuals 2,3,4.
Visual 1 howevers is provided in order to give a benchmark regarding how am i cimparison with the other farmers in the data model.
So if i have farmers 11,12,13
when farmer 11 is loged it, he should see only his data in visual 2,3,4 as well as in the slicer for "MR"
but the value for the entire dataset for all the farmers in visual 1.
As RLS is implemented on the data set, even if i write a different meaure which cancels filter context on the "MR" dimension column, still RLS will not allow farmer 11 to see the value that includes farmers 12 and 13 in visual 1.
Is there a way to implement this requirement?
Hi @TalAruety,
Row-level security (RLS) restrict data at the row level of a dataset. If my understanding is right, you create visual1, visual2, visual3 and visual4 using one dataset collecting data from different farmers. So you if we create a role for the dataset, all the data in it will be effected, we can not bypass role level security for certain measure, more details, please see: Row-level security (RLS) with Power BI.
Best Regards,
Angelia
Hi @v-huizhn-msft , Thank you for the reply!
Are you familiar with a patern where i can achieve this goal?
In this case it is useful for the farmer to know how has he performed with comparison to his peers.
I see 3 possible options:
First option should achieve that, but then inflate my model and need to maintain redundunt set of meaures
Second option can work but as dashboards are static i have to generate a representation for each scenario, ending with ton of dashboards.
Any better suggestions?
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |