Forum Discussion
SSAS Live connection with row level security on Report Server
Hi Anonymous
I had the issue resolved.
Setup the Roles in SSAS Tabular layer. And then based on the user logged in, RLS will be applied from PBI RS to SSAS.
Let me know your exact issue, so that i can help as much i can.
Thanks
Manoj
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!
saykaskuResolver I
Hi,
Try this:
1. Create pbix with measure USERNAME()
2. Check result string
3. Upload this pbix to RS
4. Check result string on RS
5. Compare them.
Are they same strings?
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
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
Hi,
We are also facing same issue. Data doesn't filtering SSAS RLS even hard coded value.
Could you share us the fix deatials .
Thanks,
Suresh
- d_gosbell
Super User
Anonymous wrote:
We are also facing same issue. Data doesn't filtering SSAS RLS even hard coded value.
How are you testing this? You should be aware that users in the SSAS Admin role do not get RLS applied to them. So if you are creating a role and adding yourself this is not a good test. You need to add a non-admin account and test using that.
