Alternative method to Add-AzAnalysisServicesAccount for connecting to Azure Analysis Service using MSAL

Rajmohan Ponnurangam 0

What is an alternative method to Add-AzAnalysisServicesAccount module for connecting to Azure Analysis Service from a PowerShell task using MSAL? We are currently using the Add-AzAnalysisServicesAccount module which internally uses ADAL, however, as ADAL is no longer supported, we want to migrate our process to MSAL. We have tried to find a new version or alternative for Add-AzAnalysisServicesAccount that uses MSAL but have been unsuccessful. We would appreciate any suggestions and guidance on how to achieve this migration to MSAL.

BhargavaGunnam-MSFT 26,221 Reputation points Microsoft Employee

2023-07-14T20:10:16.5033333+00:00

Hello Rajmohan Ponnurangam,

Welcome to the Microsoft Q&A platform.

We are reaching out to the internal team to get more details on your ask. I will get back to you as soon as I have an update.

Thank you for your patience.
Rajmohan Ponnurangam 0 Reputation points

2023-07-15T00:20:01.31+00:00

Thanks for the response. One more question, We are using PowerShell 3., if we use 5. will it internally use MSAL for authentication. We see 3.* uses AzureRM modules and 5.* uses AZ modules for connecting to Azure.

Limitless Technology 43,941

Hello there,

To connect to Azure Analysis Services using MSAL (Microsoft Authentication Library) instead of the Add-AzAnalysisServicesAccount cmdlet, you can use the following steps:

Install the MSAL module: Open PowerShell and install the MSAL.PS module by running the following command:
powershell
Copy code
Install-Module -Name MSAL.PS
Import the MSAL module: Import the MSAL.PS module into your PowerShell session by running the following command:
powershell
Copy code
Import-Module -Name MSAL.PS
Register an application in Azure Active Directory (AD): Register an application in Azure AD to obtain the necessary client ID and redirect URI. This will allow your application to authenticate and access Azure Analysis Services. Make sure to note down the client ID and redirect URI for the next steps.

Create a new MSAL PublicClientApplication: Use the client ID and redirect URI obtained from the previous step to create a new PublicClientApplication object in your PowerShell script. This object will be used for authentication.

powershell
Copy code
$clientId = "your_client_id"
$redirectUri = "your_redirect_uri"

$msalApp = [Microsoft.Identity.Client.PublicClientApplicationBuilder]::Create($clientId)
    .WithRedirectUri($redirectUri)
    .Build()
Acquire an access token: Use the AcquireTokenInteractive method of the PublicClientApplication object to prompt the user to sign in and acquire an access token for Azure Analysis Services.
powershell
Copy code
$scopes = "
$account = $msalApp.GetAccountsAsync().Result[0]

$accessToken = $msalApp.AcquireTokenInteractive($scopes)
    .WithAccount($account)
    .ExecuteAsync().Result.AccessToken
Connect to Azure Analysis Services using the access token: Now that you have the access token, you can use it to connect to Azure Analysis Services. Here's an example of how to use the AdomdClient to establish a connection:
powershell
Copy code
$serverName = "your_server_name"
$databaseName = "your_database_name"

$connectionString = "Provider=MSOLAP;Data Source=$serverName;Initial Catalog=$databaseName;"

$connection = New-Object Microsoft.AnalysisServices.AdomdClient.AdomdConnection($connectionString)
$connection.AccessToken = $accessToken

$connection.Open()
# Perform analysis operations using the connection
$connection.Close()
By following these steps, you can connect to Azure Analysis Services using MSAL in PowerShell. Ensure that you have the necessary permissions and access rights to authenticate and access the Azure Analysis Services instance.


I used AI provided by ChatGPT to formulate part of this response. I have verified that the information is accurate before sharing it with you.

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer–

Rajmohan Ponnurangam 0 Reputation points

2023-07-17T11:11:16.8866667+00:00

We are not Using ADOMD client to connect. AzAnalysisServicesAccount is used to connect to Analysis service.

1 answer

BhargavaGunnam-MSFT 26,221 Reputation points Microsoft Employee

2023-07-20T18:45:34.1866667+00:00

Hello Rajmohan Ponnurangam,

<update>

Az.AnalysisServices cmdlets call AMO for authentication. As long as you have the latest AMO on where the module is running from, you should use MSAL instead of ADAL.

You can get the latest AMO here: Analysis Services client libraries | Microsoft Learn

I hope this helps. Please let me know if you have any further questions.

If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment