question

RAVISHANKARRDHLITServices-5573 avatar image
0 Votes"
RAVISHANKARRDHLITServices-5573 asked AnshulKumarMINDTREELIMITED-5501 commented

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

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


azure-active-directoryazure-ad-authentication
issue.jpg (12.9 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, if the posted answer resolves your question, please mark it as the answer by clicking the check mark. Doing so helps others find answers to their questions.

0 Votes 0 ·
shashishailaj avatar image
0 Votes"
shashishailaj answered RAVISHANKARRDHLITServices-5573 converted comment to answer

Hello @RAVISHANKARRDHLITServices-5573 ,
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.




image.png (94.8 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RAVISHANKARRDHLITServices-5573 avatar image
1 Vote"
RAVISHANKARRDHLITServices-5573 answered shashishailaj commented

Hi,

I got the issue resolved for my error by updating the latest Analysis client libraries from Microsoft link is given below
https://docs.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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@RAVISHANKARRDHLITServices-5573 ,

Thank you for the pointers. I will test it in my lab and update my answer as well . Thank you so much for sharing this with the community . Can you confirm if you were using any Hotmail.com/outlook.com/live.com account and a bit about your scenario . Did you get an invitation on your Microsoft account to access and collaborate on the PowerBI report and you were getting the error earlier with your Microsoft account or it was some other scenario . I just want to make sure my assumptions are correct and it is a B2B scenario that you were testing when you got the error.

0 Votes 0 ·
RAVISHANKARRDHLITServices-5573 avatar image
0 Votes"
RAVISHANKARRDHLITServices-5573 answered

@shashishailaj 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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.