Live connection SSAS role not working

[Delion]

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 

[v-kkf-msft]

Hi @Delion ,

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

[v-kkf-msft · Accepted solution]

Hi @Delion ,

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

[willjoe]

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