Microsoft Authenticaton is throwing error as :This server does not supported with Microsoft Account Authentication"

RAVISHANKAR R (DHL IT Services) 6 Reputation points
2021-07-09T12:36:24.597+00:00

Hi ,

We are trying to connect azure analysis services cube through Power BI report , where when we try to establish the connection through Microsoft Account it throwing error saying This server does not support Microsoft account athuthentication.113382-issue.jpg

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
19,454 questions
{count} votes

3 answers

Sort by: Most helpful
  1. RAVISHANKAR R (DHL IT Services) 6 Reputation points
    2021-07-13T11:03:49.893+00:00

    Hi,

    I got the issue resolved for my error by updating the latest Analysis client libraries from Microsoft link is given below
    https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions

    Even after this update if you receive the same error , then you may need to add your Client IP address on your azure analysis services firewall then its working fine.

    1 person found this answer helpful.

  2. Shashi Shailaj 7,581 Reputation points Microsoft Employee
    2021-07-09T17:02:22.217+00:00

    Hello @RAVISHANKAR R (DHL IT Services) ,
    This is by design . You require to logon to the azure Analysis services using Organizational accounts only . If you try to logon with a LiveID / Microsoft Personal account you would get the error above.

    If we try to add the personal account as an administrator on the analysis services instance in the azure portal , it also fails with the following :-

    • "Error while applying server administrator changes to the Azure Analysis Services server. The user or application: '' was not found in your organization's Azure Active Directory. Details: ''."

    113434-image.png

    Hope this clarifies the doubt . In case the information provided is helpful , please do accept the post as answer so that it benefits other members of the community . If you have further queries , please feel free to let us know and we will be happy to assist.

    Thank you.

    0 comments No comments

  3. RAVISHANKAR R (DHL IT Services) 6 Reputation points
    2021-07-15T07:43:05.643+00:00

    @Shashi Shailaj This issue occurred with my customer who is from the UK region where when he tried to access the cube from the Power BI report he got his Microsoft authentication error, before that he was enabled with Multifactor authentication for his account. Even then he got the same error, we asked him to update the client libraries for SSAS still issue persists.

    We found that this particular region firewall IP range was missing in Azure Analysis Services so people in that region was having same issue ,later once we add the range of IP all those users can able to access the cube from Power BI.

    0 comments No comments