RLS with hierarchies (Power BI to SSAS)

• kintercity

  Valued Member

  Points: 64

  More actions

  September 8, 2023 at 2:00 pm

  #4282505

  I have an RLS model with organisational hierarchy and in Power BI this role works exactly as expected using the following filter:

  PATHCONTAINS(RLS_Person[Path],

  MAXX(

  FILTER(

  RLS_Person,

  [Email] = USERPRINCIPALNAME()

  )

  ,RLS_Person[ID]

  )

  )

  However, my company uses an SSAS Tabular Model to which Power BI connects to using a live connection.

  I'm new to SSAS, so I've tried to replicate the above RLS in SSAS using:

  =PATHCONTAINS(RLS_Person[Path], LOOKUPVALUE(RLS_Person[ID], RLS_Person[Email], USERPRINCIPALNAME()))

  To no avail.

  It will work for individuals at the bottom of the hierarchy who have no subordinates, so they are able to look at only their own data, but anyone higher up can see all data and not only that of their team.

  The RLS_Person table has a 1:1 relationship to the Sales_Person table which has a 1:* relationship to the Fact table.

  Any suggestions welcome!

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  September 9, 2023 at 2:10 pm

  #4283144

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.