Forum Discussion
How to do Row Level Security in PBI Report Server using live connection from SSAS cube
rincewind wrote:
Some more information:
- In Manage options for the report, Data Sources > Credentials > Authentication Type is Windows Authentication. And the option "use the following credentials" is selected. A username and password has to be entered in the field there. This was provided by the admin team. I'm not sure what the use of this is but thought I should mention.
This is most likely your issue. When you have it configured this way the only user the cube sees connecting is the one entered in the data source.
When using RLS you should either use the credentials option of "As the user viewing the report" (although this may require that your IT department configure Kerberos Authentication)
Or the other option is to try clicking the checkbox under the "Use the follow credentials" option that says to try impersonating the current user. The most comprehensive write up I've seen of this option is here http://www.artisconsulting.com/blogs/greggalloway/2010/4/1/using-effectiveusername-to-impersonate-in-ssas and although the screenshots are from an older version of SSRS I think the core mechanism still works the same.
rincewind wrote:
Some more information:
- In Manage options for the report, Data Sources > Credentials > Authentication Type is Windows Authentication. And the option "use the following credentials" is selected. A username and password has to be entered in the field there. This was provided by the admin team. I'm not sure what the use of this is but thought I should mention.
This is most likely your issue. When you have it configured this way the only user the cube sees connecting is the one entered in the data source.
When using RLS you should either use the credentials option of "As the user viewing the report" (although this may require that your IT department configure Kerberos Authentication)
Or the other option is to try clicking the checkbox under the "Use the follow credentials" option that says to try impersonating the current user. The most comprehensive write up I've seen of this option is here http://www.artisconsulting.com/blogs/greggalloway/2010/4/1/using-effectiveusername-to-impersonate-in-ssas and although the screenshots are from an older version of SSRS I think the core mechanism still works the same.
thank you! d_gosbell What you suggested worked! I just had to check that one box and Row Level Security started working!
Thanks again!
