Overview

When configuring an Azure Analysis Services (AAS) endpoint you can choose to authenticate using one of two methods:

Method 1: Use an Azure Active Directory (AAD) account. This account will need to have multifactor authentication (MFA) disabled and the account will need to have admin permissions on the AAS instance.

Method 1: Azure Active Directory (AAD) account

1. Login to the Azure portal where your AAS instance resides.

2. Navigate to the AAS instance and navigate to Settings → Analysis Services Admins.

3. Click Add and choose an AAD account.

Note: Account must not have MFA enabled

4. Click Save

5. In the Jet Data Manager navigate to the Analysis Services endpoint and under Server login: enter the AAD account and password.

1. Login to the Azure portal where your AAS instance resides.

2. Navigate to App registrations and click New registration

3. Provide a name, choose your supported account type as shown below and click Register.

4. From the newly created App registration click Certificates & secrets.

5. Click New client secret.

6. Add a description and specify when the client secret will expire.

Note: Save the client secret value as you will not be able to view it again.

7. Next open up an instance of SQL Server Management Studio (SSMS) and connect to your AAS instance.

8. Right click on the AAS instance and click Properties and navigate to the Security page.

9. Seach for the application name and choose the app.

Note: If your App registration is not visible in the search result, you may enter it manually
using the following format: app:<app-ID>@<tenant-ID>

10. Verify the entry has been added and click OK.

11. In the Jet Data Manager navigate to the Analysis Services endpoint and under Server login:

Enter the app registration id prefixed with "app:" as shown below. For the password you will use the client secret value from step 6.