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 0

I am looking for a way to achieve this using Python. Please suggest any tools, libraries, or approaches that can facilitate this, such as using REST APIs or handling XMLA directly. A step-by-step explanation or references would be greatly appreciated.

phemanth 12,580 Microsoft Vendor

@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.

T, Charandeep 0 Reputation points

2024-12-04T06:09:59.15+00:00

@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.
phemanth 12,580 Reputation points Microsoft Vendor

2024-12-04T17:55:56.36+00:00
@T, Charandeep

Please check the below steps and confirm us

Server Name: Ensure that <your-server-name> is replaced with the actual name of your Azure Analysis Services server.

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.

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"
phemanth 12,580 Reputation points Microsoft Vendor

2024-12-05T20:00:03.2466667+00:00

@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.
phemanth 12,580 Reputation points Microsoft Vendor

2024-12-09T18:08:25.61+00:00
@T, Charandeep

Thanks, Here are a few things to check:

Verify the Server Name: Ensure that myserver is the exact name of your Azure Analysis Services server. You can find this in the Azure portal under your Azure Analysis Services server details.

Check DNS Resolution: Sometimes, DNS resolution issues can cause this error. You can try pinging the server name from your command line to see if it resolves correctly:
ping myserver.asazure.windows.net

Use the Correct Endpoint Format: The correct format for the Azure Analysis Services endpoint should be:
https://<your-server-name>.asazure.windows.net/xmla
Make sure there are no typos or extra spaces.

Network Configuration: Ensure that your network allows outbound HTTPS traffic to the Azure Analysis Services endpoint. Sometimes, firewall or proxy settings can block the connection.

Alternative Endpoint: If you’re using Power BI Premium, the endpoint format might be different. For Power BI, the format is typically:
powerbi://api.powerbi.com/v1.0/myorg/<workspace-name>

I hope the above steps will resolve the issue, please do let us know if issue persists. Thank you

1 answer

T, Charandeep 0 Reputation points

2024-12-06T07:27:52.5133333+00:00

@phemanth
I tried this url = "https://myserver.asazure.windows.net/xmla"

still it is having the same error mentioned above.
Please sign in to rate this answer.

0 comments No comments
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, preferably using Python?

1 answer

Your answer