DataDiva's avatar
DataDiva
Icon for Advocate II rankAdvocate II
7 years ago
Status:
New

RLS does not work with firstnonblank/lastnonblank/selectedvalues

There seems to be a bug in how RLS relates to firstnonblank/lastnonblank/selectedvalues kind of formulas. If you use one of these formulas on a table that is filtered by RLS, it will bring in data as...
Data Modeling
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

DataDiva ,

 

I can reproduce this issue. But RLS will be applied to other tables when they have relationship with each other. So if you don't build a relationship between Location and MyLocation based on column [Location Key], RLS will not be applied to other tables. 

 

My sample tables are like below:

 

In my test, I have input RLS rule below on 'Location':

  

 

Then I add the column using DAX:

Column = LOOKUPVALUE(
    'MyLocation'[Location Value],
    'MyLocation'[Location Key],
    'Location'[Location Key]
)

The result is not the expect result as he said.

 

But If we build a relationship between table 'Location' and 'MyLocation', the result will be normal.

 

 

Regards,

Jimmy Tao

Completed Ideas