Forum Discussion
Live connection SSAS role not working
- 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 ServicesIf 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
- In Tabular Model Explorer, right-click Roles > Roles.
- In Role Manager, click New.
- Click on the new role, and then in the Name column, rename the role to Sales Manager.
- In the Permissions column, click the dropdown list, and then select the Read permission.
Regards,
Will