topic Re: RLS based on Category in Report Server

RLS based on Category

prajaktakeni11 — Thu, 30 Nov 2023 14:51:06 GMT

Hello ,
I have employee data with different role , I want to restrict data based on Resource type
for example Employee (1) has resource type A and is location head can view only his data being a location head and related resource data fromsales table

can you please help

Re: RLS based on Category

lbendlin — Sat, 02 Dec 2023 22:14:35 GMT

I assume you have a reference table in your data model that maps USERPRINCIPALNAME to resource type?

Re: RLS based on Category

prajaktakeni11 — Mon, 04 Dec 2023 07:12:14 GMT

I do have a Refrence Table , with USERNAME we are mapping it to Resource Type

Re: RLS based on Category

lbendlin — Mon, 04 Dec 2023 12:31:02 GMT

Needs to be USERPRINCIPALNAME. their email address, basically.

Re: RLS based on Category

prajaktakeni11 — Mon, 04 Dec 2023 12:58:35 GMT

lbendlin Can't we do it with employee id USERNAME()......?,
and Could you please help me out on dax how can I restrict data based on Type for specific People

Re: RLS based on Category

lbendlin — Mon, 04 Dec 2023 15:44:47 GMT

For dynamic RLS you don't need anything else, but it must use USERPRINCIPALNAME, and your reference table must control the fact tables of the data model.

Re: RLS based on Category

prajaktakeni11 — Tue, 05 Dec 2023 12:55:32 GMT

Okay and what would be my dax to filter the data as per specific category ?

Re: RLS based on Category

lbendlin — Tue, 05 Dec 2023 13:32:36 GMT

There is no DAX filter, this is all controlled via the data model.