How do I add a user that has an apostrophe in their user principal name as a member of Azure Analysis Services cube role

Rick Dayman 1 Reputation point
2021-05-05T20:55:40.13+00:00

I'm thinking this is more of a bug than a question.

I'm developing Power BI dashboards sourced from Azure Analysis Services and have a user where their email and user principal name have an apostrophe in it (lets just say it's blah.O'Blah@mathieu.company .co.nz) and until about a couple of weeks ago this user has had no problems viewing the Power BI dashboards but is now getting the [Cannot Connect to Data Model] error

This user is actually part of a group that has membership to a cube role (actually more than one) but I've been trying to add this user individually and I'm hitting errors with everything I've tried

I can [Add Member] from SSMS/Roles and search for them, find them but when I click add I get a "This user was not found in your organisation azure active directory" error

If I add the user email manually I get the same error

If I use an XMLA script I get the same error

Also access via the group they're in gives the same error

But if I use double apostrophe (as in Blah.O''Blah@mathieu.company .co.nz) then then no error and it would seem that they've been added to the cube and hence data model but then they still get the [Cannot Connect to Data Model] error from Power BI

I'm thinking something has recently changed in how they get authenticated and now the apostrophe is causing issues

I created a Power BI report that just shows their user name and user principal name not connected to a cube and this just shows the one apostrophe scenario

So from the cube side there is an issue with the one apostrophe and from the power bi and azure side there isn't and this is causing issues

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,455 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rick Dayman 1 Reputation point
    2021-05-10T23:54:42.363+00:00

    Hi

    I created a Power BI report that had an 1 column 1 row table (created by using enter data) in order to create a measure that returned USERPRINCIPALNAME() and USERNAME() and just put each of them into a Card object, this was just to see if the user had any issues opening the report, but they didn't, which implied the issue is with access to the azure analysis services data model the other reports are based on but the problem has since been solved by removing the apostrophe from the users (principal name)

    0 comments