Azure Analysis Services and user account with an apostrophe

Jorge L Dominguez 46

The principal user name exists in Azure AD; the issue comes when adding the user account to the analysis services. As per the message below ( I have substituted the real user name, surname and domain name ), I can see that the apostrophe causes the issue.

Failed to save modifications to the server. Error returned: 'The user or application: '<pii>UserName.O'UserSurname@Somedomain.org.au</pii>' was not found in your organization's Azure Active Directory. Details: '<pii>The remote server returned an error: (400) Bad Request.</pii>'.

The interesting thing is that this did not happen a few days back. I mean to say that the user has been accessing the service with no issues until recently.

How do I add a user with an apostrophe in their name as a member of azure analysts services?

Saurabh Sharma 23,791 Reputation points Microsoft Employee

2021-05-12T01:07:21.583+00:00

Hi @Jorge L Dominguez ,

Thanks for using Microsoft Q&A !!
Are you trying to add the user as analysis services admin and getting this error ? I have tried to add the user using RBAC and it worked fine however when I tried to add the user as an analysis service admin and I see the below error.

I am checking internally with the products team and get back to you on the same.

Thanks
Saurabh
Jorge L Dominguez 46 Reputation points

2021-05-12T03:54:16.553+00:00
Hi @ SaurabhSharma-msft

Adding the user to the Analysis Services role via SSMS

Select user from the picklist

The user with the apostrophe is visible in the roles list

Click OK to add and error message comes-up
Saurabh Sharma 23,791 Reputation points Microsoft Employee

2021-05-12T16:02:16.167+00:00

Hi @Jorge L Dominguez ,

Got it and I have received confirmation from products team that this is a known issue which they are already working on the fix. I do not have any ETA but I will update you when the fix will be available in production.

Thanks
Saurabh
Jorge L Dominguez 46 Reputation points

2021-05-12T23:11:27.137+00:00

Hi @ SaurabhSharma-msft

Thank you for the reply; much appreciated. I'll wait for your notification.

Regards
George

Accepted answer

Saurabh Sharma 23,791 Reputation points Microsoft Employee

2021-05-17T19:47:56.347+00:00

Hi @Jorge L Dominguez ,

This behavior has been identified as a known product issue and the products team is working on the fix. I do not have any ETA of the fix but I will update the thread as soon as I hear back any updates from them. My apologies for your trouble.

Thanks
Saurabh
Please sign in to rate this answer.
Saurabh Sharma 23,791 Reputation points Microsoft Employee

2021-06-01T18:00:39.08+00:00

Hi @Jorge L Dominguez ,

This issue has been fixed in Production environment. Can you please try it out and let me know if the scenario is working now.

Thanks
Saurabh

Jorge L Dominguez 46 Reputation points

2021-06-01T22:12:17.393+00:00

Hi SaurabhSharma-msft,

I can confirm that the issue has been fixed.

Regards
George

Saurabh Sharma 23,791 Reputation points Microsoft Employee

2021-06-01T22:13:39.443+00:00

Hi @Jorge L Dominguez ,

Great to hear. Thanks for the confirmation.

Thanks
Saurabh
Sign in to comment

Share via

Azure Analysis Services and user account with an apostrophe

0 additional answers