Security Restrictions (Maybe RLS query)

[ChrisiB]

Hello,

I'm relatively new to Power BI and have just joined in on the creation of a company dashboard. One of the things I am currently planning ahead for involves what I suspect is Row Level Security - and unfortunately I can't appear to locate a similar thread in the forum.

Essentially the group contains a set of companies that need reporting on an individual basis [each measure has 1 value for each company] (I have established I can do this via Row Level Security) but each measure also requires a group average [this would effectively be the total of the measure] however when I tested this, the aggregate was affected by the row level security (as expected as the data access for the other companies is restricted).

Is it possible to have some form of restriction so that the dashboard only allows viewing of the measure for that company, and also allows an aggregate of the measure including all the companies (that isn't affected by RLS)

Many thanks, Chris

[v-yuezhe-msft · Accepted solution]

@ChrisiB,

I am not sure how your tables look like. But you can make a copy of your fact(data) table, then create a measure in the new table to calculate the total value, please note the the new table has no relationship with other tables.

This way, when you define RLS in the old tables of the dataset, it will not impact the total measure.

Regards,
Lydia

[ChrisiB]

Hi Lydia,

Many thanks for your suggestion