Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Report server data source credentials question

Hi,   Could someone tell me what the highlighted option means on the data source credentials properties tab below?   I've noticed that if I select this option after entering the required data sou...
Credentials Prompt
  • josef78's avatar
    josef78
    3 years ago

    This checkbox enable user impersonation, e.g. for live connected report to SSAS. This means:

     

    Report will connect (authentificate) to source using provided username and password (some technical account). But after authentification will be impersonate (authorized) as real user who using this report.

     

    This is important for live connected Analysis Services databases with RLS (Row Level Security) roles, when you need to know which user is viewing this report.

josef78's avatar
josef78
Icon for Memorable Member rankMemorable Member
3 years ago

This checkbox enable user impersonation, e.g. for live connected report to SSAS. This means:

 

Report will connect (authentificate) to source using provided username and password (some technical account). But after authentification will be impersonate (authorized) as real user who using this report.

 

This is important for live connected Analysis Services databases with RLS (Row Level Security) roles, when you need to know which user is viewing this report.