Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

SSAS Live connection with row level security on Report Server

Hi,   I am using SSAS Tabular model created and using in Power BI report server. We have new security requirement of users logging and what they get to see in report.   When i connect to SSAS Liv...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago
Dear Anonymous
I tried to create a rule on SSAS layer and when I login into PRS with the same account the i had made the rule on , It doesn’t filtering the data the way I want, it still shows me the whole data
Could you help me please!
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous 

 

please check what is username() resolving to in SSAS and PBIRS, both should be same, else DAX forumla wouldnt work.

 

1. Create a meauser in SSAS with username() - see what it resolves to

2. Create a regular pbi report with username() measure displayed in a table visual - see what it resolves to

 

Both these should be same, most cases domain\username

If both are same in your case and still data doesnt get filtered, please share your DAX formula.

 

Thanks

Manoj

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous  

    Hope you doing great!

    I have some question for you :

    1- username() in SSAS is it used as a measure? or Roles?

    2-username () in PB is it measure? because of the role in PRS is unavailable?

    3-Could you please share your username():smileysad:?

    4- Do you have a table created with a username()?

     

    I always thankful