Forum Discussion

jdusek92's avatar
jdusek92
Icon for Advocate III rankAdvocate III
7 years ago
Solved

RLS - Analyze in Excel connection

  Hello, I have successfully set up row level security using this Table filter DAX expression: SEARCH( userprincipalname(), [Email], 1, 0 ) > 0   I am now experimenting with "analyze in Excel" f...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi , jdusek92

    1. It is PERMANENTLY, You can use it next time you open it, also it will verify your account.

    3. reliable, although I can't find the relevant documents for you, Unreliable Microsoft won't use it.

    4. Impossible, Security has always been a major concern for Microsoft.

     

    Best Regards,

    Lin

jdusek92's avatar
jdusek92
Icon for Advocate III rankAdvocate III
7 years ago

Hello v-lili6-msft thank you for your reply. 

what you say is completely clear to me and is not a part of my question - RLS works as expected - owner sees all and other users assigned to RLS role sees filtered data.

 

My question is about thr linked data table obtained via drilling through OLAP pivot table (created by Analyze in Excel)

 

Warm regards

Jakub

jdusek92's avatar
jdusek92
Icon for Advocate III rankAdvocate III
7 years ago

This is how I get the linked table I have questions about: