Azure guest user authentications issues - Excel and PowerBI asking for authentications all the time

asked 2020-08-25T15:35:56.437+00:00
ZDUAN 1 Reputation point

Hello, I have an Analysis Service instance running on Azure. Based on this AAS, my users are invited as guest users in my AD tenant. And they are allowed to read the data in AAS through Excel or PowerBI. They have accepted the invitations and created their ID&Pwd, even MFA with email/phone.

Now, we have a problem at the part of logging. For users who log in with Excel and PowerBI, azure keeps asking authentications, even they have already correctly enter their ID&Pwd 3 times.

I did not find the documents to configure this part or similar issues on FAQ.

Thanks in advance if you can have a look at this issue.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
8,467 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. answered 2020-08-26T09:05:32.597+00:00
    Cris Zhan-MSFT 6,561 Reputation points

    Hi,

    I suggest you post your question in the dedicated forum--Azure Analysis Services forum(tag your post: azure-analysis-services). It is more appropriate and more experts would help there.

    Also please check following links if help:
    https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-manage-users

    ===============================================

    If the response helped, do "Accept Answer" and upvote it.