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 ...
  • v-kkf-msft's avatar
    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