powershell - Azure Automation Analysis Services Processing -
i come across unexpected error, when trying process table in azure analysis services using azure automation. have followed tutorial suggesting using powershell gallery module - sqlserver invoke-processtable
. final code in azure automation looks this:
$azurecred = get-automationpscredential -name "ks" add-azurermaccount -credential $azurecred | out-null invoke-processtable -credential $azurecred -databasename dbname -refreshtype "full" -server servername -tablename tablename
unfortunatelly, end with:
invoke-processtable : exception has been thrown target of invocation. @ line:25 char:1 + invoke-processtable -credential $azurecred -databasename dbname -r ... + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + categoryinfo : notspecified: (:) [invoke-processtable], targetinvocationexception + fullyqualifiederrorid : system.reflection.targetinvocationexception,microsoft.analysisservices.powershell.cmdlets.processtable
additionally, have tested invoke-processtable
code locally , works perfectly. credentials used of person both admin access analysis services , subscription using.
i appreciate suggestions.
Comments
Post a Comment