Forum Discussion

hereri's avatar
hereri
Frequent Visitor
9 years ago
Solved

Problems with security when using Live connection to SSAS Tabular

For one of our customers we have implemented row based security in SSAS Tabular using roles, and then adding members to these roles. When connecting to SSAS Tabular from Power BI the set filters are ...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi hereri,

     

    In your scenario, did your Power BI service login names match your local directory UPN on SSAS side? If not, please check if you set the Mapping User Roles in on-premise data gateway. For more information, see: Map user names.

     

    Also verify the user is not the admin on the server, please refer to AlexeyRusinov's reply in this thread: Enterprise Gateway with Analysis Services not passing logged in users credentials .

     

    If issue persists, please share the detail steps about how you set row level security and the on-premise data gateway version for our analysis.

     

    Best Regards,
    Qiuyun Yu

     

     

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi hereri,

 

In your scenario, did your Power BI service login names match your local directory UPN on SSAS side? If not, please check if you set the Mapping User Roles in on-premise data gateway. For more information, see: Map user names.

 

Also verify the user is not the admin on the server, please refer to AlexeyRusinov's reply in this thread: Enterprise Gateway with Analysis Services not passing logged in users credentials .

 

If issue persists, please share the detail steps about how you set row level security and the on-premise data gateway version for our analysis.

 

Best Regards,
Qiuyun Yu

 

 

 

  • hereri's avatar
    hereri
    Frequent Visitor
    9 years ago

    Hi v-qiuyu-msft, 

     

    Thank you for your reply. I did find the answer to my problem. In the map user functionality you can decide if you want to use EffectiveUserName or CustomData. Since my browser was in Norwegian the translated text completely threw me off and I did not see the relevance between that option, and how Power BI pushed UPN to SSAS. 

     

    Thanks alot for your help :)