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

@T, Charandeep

Thanks for reaching out to Microsoft Q&A.

You can update the data source for Azure Analysis Services using Python by leveraging the Azure REST API and handling XMLA (XML for Analysis).

Step-by-Step Guide

Ensure you have Python installed.

Install necessary libraries:

  pip install requests azure-identity

Use the azure-identity library to authenticate and obtain an access token.

  from azure.identity import DefaultAzureCredential
  credential = DefaultAzureCredential()
  token = credential.get_token("https://management.azure.com/.default")
  headers = {
      "Authorization": f"Bearer {token.token}",
      "Content-Type": "application/xml"
  }
  
  

Create the XMLA script to update the data source. Here’s an example:XML

<Alter xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Object>
    <DatabaseID>YourDatabaseID</DatabaseID>
  </Object>
  <ObjectDefinition>
    <Database>
      <DataSources>
        <DataSource xsi:type="RelationalDataSource">
          <ID>YourDataSourceID</ID>
          <Name>YourDataSourceName</Name>
          <ConnectionString>YourNewConnectionString</ConnectionString>
        </DataSource>
      </DataSources>
    </Database>
  </ObjectDefinition>
</Alter>

Use the requests library to send the XMLA command to the Azure Analysis

  import requests
  xmla_command = """
  <Alter xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
    <Object>
      <DatabaseID>YourDatabaseID</DatabaseID>
    </Object>
    <ObjectDefinition>
      <Database>
        <DataSources>
          <DataSource xsi:type="RelationalDataSource">
            <ID>YourDataSourceID</ID>
            <Name>YourDataSourceName</Name>
            <ConnectionString>YourNewConnectionString</ConnectionString>
          </DataSource>
        </DataSources>
      </Database>
    </ObjectDefinition>
  </Alter>
  """
  url = "https://<your-server-name>.asazure.windows.net/xmla"
  response = requests.post(url, headers=headers, data=xmla_command)
  if response.status_code == 200:
      print("Data source updated successfully.")
  else:
      print(f"Failed to update data source: {response.content}")
   

References

• Azure Storage samples using Python
• Azure SDK for Python

Hope this helps. Do let us know if you any further queries.

@phemanth
I tried this url = "https://<your-server-name>.asazure.windows.net/xmla"

but it is showing error like requests.exceptions.ConnectionError: HTTPSConnectionPool(host='<servername>.asazure.windows.net', port=443): Max retries exceeded with url: /xmla (Caused by NameResolutionError("<urllib3.connection.HTTPSConnection object at 0x00000167FF876D80>: Failed to resolve '<servername>.asazure.windows.net' ([Errno 11001] getaddrinfo failed)"))

`

looks like endpoint was not valid kindly check and let me know.

@T, Charandeep

Please check the below steps and confirm us

1. Server Name: Ensure that <your-server-name> is replaced with the actual name of your Azure Analysis Services server.
2. Endpoint URL: Verify that the endpoint URL is correct. You can find the correct endpoint URL in the Azure portal under your Azure Analysis Services resource.
3. DNS Resolution: Ensure that your DNS settings are correctly configured to resolve the Azure Analysis Services server name.

If your server name is myserver, the endpoint URL should be:

url = "https://myserver.asazure.windows.net/xmla"

@T, Charandeep We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.