Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Live connection SSAS role not working

Hi 

 

I have problem with SSAS role :

User A = assigned in City A = can view data only City A in dashboard

User B = assigned in City B = showing error like below

All setting for this both user same except the City and if I set Admin view for User B , dashboard can show all data again

 

Please help 

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Anonymous ,

     

    Each time a user interacts with Analysis Services, the effective user name is passed to the gateway and then on to your on-premises Analysis Services server.  When your user name in Azure Active Directory (Azure AD) doesn't match a UPN in your local Active Directory instance, you need configure rules to map a user name signed in with Power BI to a name that's passed for EffectiveUserName on the Analysis Services connection. 

    So please check that you have mapped to the correct role for the end user.


    For more information, please refer to: Manage your data source - Analysis Services 

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quick

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago
    Create roles
    1. In Tabular Model Explorer, right-click Roles > Roles.
    2. In Role Manager, click New.
    3. Click on the new role, and then in the Name column, rename the role to Sales Manager.
    4. In the Permissions column, click the dropdown list, and then select the Read permission.

     

    Regards,

    Will

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    Each time a user interacts with Analysis Services, the effective user name is passed to the gateway and then on to your on-premises Analysis Services server.  When your user name in Azure Active Directory (Azure AD) doesn't match a UPN in your local Active Directory instance, you need configure rules to map a user name signed in with Power BI to a name that's passed for EffectiveUserName on the Analysis Services connection. 

    So please check that you have mapped to the correct role for the end user.


    For more information, please refer to: Manage your data source - Analysis Services 

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quick

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous ,

     

    Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.


    Best Regards,
    Winniz