Query MDX to csv

query-aas.ps1

$creds = Get-AutomationPSCredential -Name "ServPpalName"

# AAS Server to query
$server = "asazure://*.asazure.windows.net/*"

# Create xml object to parse response
[xml] $xmlDoc = New-Object system.Xml.XmlDocument

# Query definition
$AAS_db = "AAS_MODEL_NAME"
$query = 'SELECT * FROM $SYSTEM.DBSCHEMA_CATALOGS'

# Make the query and parse result
$return = Invoke-ASCmd -Server $server -Query $query -Database $AAS_db -Credential $creds -ServicePrincipal
$xmlDoc.LoadXml($return)
$result = $xmlDoc.return.root.row | Select-Object {$_.CATALOG_NAME, $_.DATE_MODIFIED, $_.DATE_QUERIED, $_.POPULARITY, $_.WEIGHTEDPOPULARITY}

# Save result as string
$csv_string = $xmlDoc.return.root.row | ConvertTo-Csv -NoTypeInformation | Out-File "$PSScriptRoot\AAS-QueryResult.csv"