Missing the Microsoft login dialog when connecting to AAS

[MartinNordestgaard]

Description

Before upgrading to 3.16 (persists in 3.16.1) I used to get a login dialog/promt/MFA for Azure/Microsoft account, where I could select the user, that I would use to login to the model. This does not show anymore after the upgrade.

I have two MS accounts which I use. One for Dev-systems (as a admin) and one "admin" for test and production environments, which I'am not longer promted to use/select.
Due to the fact, that my dev account does not have admin rights on test- and production environments I get an error (see picture).

Is this a bug?

Tabular Editor 3 Version

3.16/3.16.1

Screenshots

Steps to Reproduce

1. Open Model from DB
2. No dialog/promt box anymore
3. Automatically loggin in with my current user (linked to my "normal" MS account/PC)

Expected behavior

Get login dialog where I can selected the right account for the seleced environment

Crash Report

No response

Windows Version

Windows 10 EE

[otykier]

Hi @MartinNordestgaard

Can you confirm that the error is not present if you roll back to 3.15.0 (or whichever version you had before upgrading to 3.16.0)?
I recommend downloading the portable version to test this: https://docs.tabulareditor.com/te3/other/release-notes/3_15_0.html?tabs=downloads

Thank you!

[MartinNordestgaard]

Hi @otykier. It works if I reinstall 3.15.0

[otykier]

Thanks for confirming.

We upgraded AMO/TOM to v. 19.80.0 in TE 3.16.0, and unfortunately we have been riddled with a lot of issues since :(
We're considering creating another hotfix (TE 3.16.2), which will go back to using AMO/TOM v. 19.79.1.1 for the time being.

[otykier]

Hi @MartinNordestgaard

We have a new build ready where we've rolled back AMO/TOM to 19.79.1.1. This is the same version that we used in TE 3.15.0.

Could you give this new build a shot and see if this fixes the issue for you? Thanks!

Download options:

• 64 bit installer
• 64 bit portable
• 32 bit installer
• 32 bit portable

(Release notes identical to 3.16.1 with the addition that AMO/TOM has been downgraded to 19.79.1.1)

[MartinNordestgaard]

@otykier works perfect! Thank you guys!

[mlonsk]

Thank you for testing @MartinNordestgaard, it is much appreciated"

We have just released 3.16.2, and I am closing this issue.

[otykier]

Just an update on this. It seems that this behavior is here to stay in newer versions of the AMO/TOM client libraries, meaning that future versions of TE3 will not show the MFA popup, in some situations when an AAD/Entra ID account is already tied to Windows. However, the good news is that there is an easy way to force the MFA dialog to appear, in case you want to sign in using a different account.

In the connect dialog, either set Authentication to Username and password and specify the e-mail address of the account you with to use when connecting:

alternatively, specify a connection string that includes User ID=<email> in the Server property:

For connections to AAS or Power BI / Fabric XMLA endpoints, the following is sufficient:

Data Source=<servername>;User ID=<email>

We'll make sure to document this once we release a new version of TE3 that includes the updated AMO/TOM client libraries.