How can I update the data source (Azure Storage) for Azure Analysis Services without using the SQLServer module or the Invoke-ASCmd method?

T, Charandeep 0

Can I update the data source (Azure Storage) for Azure Analysis Services (AAS) without relying on the SQLServer PowerShell module i.e using the Invoke-ASCmd method to make the changes? Are there alternative approaches or tools available to update the data source configuration programmatically or automatically.

1 answer

Nandan Hegde 32,831 Reputation points MVP

2024-12-02T07:21:15.3+00:00

You can use Azure Devops Release task :

https://github.com/liprec/vsts-release-aas

And via TMSL script aspect, you can update the connection details or even via AAS bim file deployment aspect
Please sign in to rate this answer.
T, Charandeep 0 Reputation points

2024-12-02T09:01:11.4+00:00

Could you please explain it in more detail?

T, Charandeep 0 Reputation points

2024-12-02T09:02:06.9866667+00:00

Could you please explain it in more detail?

Smaran Thoomu 17,610 Reputation points Microsoft Vendor

2024-12-03T11:42:39.3333333+00:00

Hi T, Charandeep

I’ll provide more details on the suggested approaches for updating the data source for Azure Analysis Services (AAS).

Azure DevOps Release Task

The Azure DevOps Release Task for AAS can help manage deployments for AAS, including updating the data source configuration.

How to Use This Task:

Step 1: Install the AAS extension in your Azure DevOps environment.

Step 2: Create or update a release pipeline in Azure DevOps.

Step 3: Add a task to deploy your .bim file (which contains the updated connection details) or execute a TMSL script.

Step 4: Configure the release to use your updated .bim file or provide the TMSL script inline as part of the task.

Updating Data Source via TMSL Script

Tabular Model Scripting Language (TMSL) is a JSON-based format you can use to update the AAS model programmatically.

Example TMSL Script to Update the Connection Details:

{ "type": "update", "database": "<database-name>", "dataSources": [ { "name": "<data-source-name>", "connectionString": "AccountKey=<new-key>;BlobEndpoint=https://<new-storage-account>.blob.core.windows.net/" } ] }

Steps to Execute:

You can run this script using a tool like SQL Server Management Studio (SSMS) or integrate it into the Azure DevOps task.

Alternatively, you can use the Tabular Object Model (TOM) API to execute the script programmatically in a .NET application or other environment.

Updating Data Source via .bim File Deployment

The .bim file defines your AAS model, including data source configurations.

Steps to Modify and Deploy a .bim File:

Export the Existing Model: Use a tool like Visual Studio with the Analysis Services Projects extension to open and export your model.

Update the Data Source:

Open the .bim file in a text editor or within Visual Studio.

Locate the dataSources section and update the connectionString with the new Azure Storage details.

Deploy the Updated Model:

Use Visual Studio, Azure DevOps Release Task, or PowerShell scripts to redeploy the .bim file back to AAS.

I hope this helps. Let me know if you have any further questions.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How can I update the data source (Azure Storage) for Azure Analysis Services without using the SQLServer module or the Invoke-ASCmd method?

1 answer

Your answer