Forum Discussion

TalAruety's avatar
TalAruety
Icon for Advocate I rankAdvocate I
9 years ago

bypass role level security for certain measure

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 diffr...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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

  • TalAruety's avatar
    TalAruety
    Icon for Advocate I rankAdvocate I
    9 years ago

    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:

    1. Duplicate my Fact table, without linking it to the "MR" dimenision which filters the original data, and calcluate the measure from it
    2. create a new data set, create a dashboard and put elements from the filterd and the non filterd data in a single dashboard.

    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?