Execute XMLA against SSAS

Question

I'm using below function to execute my xmla file against a SSAS instance. $Xmla is a file that creates a db. When i execute this function, the script runs but towards the end it just opens this $Xmla file and does nothing. Also the machine running this script will not have any SQL installed as this will be run on a remote SSAS. This was my source for this function: https://jorgecandeias.github.io/2013/12/24/how-to-execute-xmla-against-ssas-in-powershell/ Am I missing anything?

function Execute-Xmla
{
    [CmdletBinding()]
    param
    (
        [Parameter(Position=0, Mandatory=$True)] [string] $TargetServerName,
        [Parameter(Position=1, Mandatory=$True, ValueFromPipeline=$True)] [string] $Xmla
    )
    begin
   {

        $ConnectionectionString = "Data Source=$TargetServerName;Provider=MSOLAP.4;Integrated Security=SSPI;Impersonation Level=Impersonate;"
        $Connection = New-Object Microsoft.AnalysisServices.AdomdClient.AdomdConnection($ConnectionectionString)
        $Connection.Open();
    }
    process
    {
        $Comand = $Connection.CreateCommand();
        $Comand.CommandTimeout = 20000;
        $Comand.CommandType = [System.Data.CommandType]::Text;
        $Comand.CommandText = $Xmla;
        $Reader = $Comand.ExecuteXmlReader();
        if($Reader.Read())
        {
            $Return = $Reader.ReadOuterXml();
        }
    return $Return;
   }
    end
    {
        $Connection.Close();
        $Connection.Dispose();
    }
};

Can you show us the code with which you call `Execute-Xmla`? — Mathias R. Jessen, May 29 '20 at 22:35
I'm running this ps1 script as: . .\FileCopy.ps1 and calling this function in next line — Tag, May 29 '20 at 22:37
Like, just `Execute-Xmla` and nothing else? If not, please [update your post](https://stackoverflow.com/posts/62095533/edit) — Mathias R. Jessen, May 29 '20 at 22:40
Execute-Xmla TargetServerName $Xmla I actually tried to hard code my server name and xmla file instead of sending it as parameters, but that doesn't work either — Tag, May 29 '20 at 22:42
If you look at the example on the page, it takes the raw XMLA, not a file, as input. `Get-Content $xml -Raw |Execute-Xmla TargetServer` — Mathias R. Jessen, May 29 '20 at 22:45

Execute XMLA against SSAS

0 Answers0