处理Azure Analysis Services

问题描述

Hello All

Hello All

我正在尝试从自动化帐户处理Azure ANalysis服务（兼容性1600）表（运行书籍） 。

I am trying to process Azure ANalysis services(Compatibility 1600) tables from Automation account(run books).

当我尝试使用Processtable它会抛出我错误

When i try to use Processtable it throws me error

这里是我使用的脚本

Import-Module -Name" SqlServer" -Verbose＃
"获取凭证..."

$ AzureCred = Get-AutomationPSCredential -Name" AutomationProcessing" 

"登录..."
$
Add-AzureRmAccount -Credential $ AzureCred | out-Null #Allow AASProcessor调用Azure Resource Manager cmdlet请求

#Process表：Dims中数据，层次结构，关系等的完整处理

"重新处理表。 .." b
Invoke-ProcessTable`

-Credential $ AzureCred`

-DatabaseName" Sales Tabular" `

-Table" Customer" `

-RefreshType Full`

-Server" asazure：//southcentralus.asazure.windows.net/SSASTabular"

" ...客户表已处理..."

Import-Module -Name "SqlServer" -Verbose #
"Getting Credentials..."
$AzureCred = Get-AutomationPSCredential -Name "AutomationProcessing" 
"Logging in..."
Add-AzureRmAccount -Credential $AzureCred | out-Null #Allow AASProcessor to invoke Azure Resource Manager cmdlet requests
#Process Tables: Full Processing of data, hierarchies, relationships etc. in Dims
"Reprocessing Tables..."
Invoke-ProcessTable`
-Credential $AzureCred `
-DatabaseName "Sales Tabular" `
-Table "Customer" `
-RefreshType Full `
-Server "asazure://southcentralus.asazure.windows.net/SSASTabular"
"...Customer Table processed..."

我得到的错误是

Invoke-ProcessTable : Cannot process command because of one or more missing mandatory parameters: TableName
DatabaseName RefreshType.
At line:12 char:2
+     Invoke-ProcessTable
+     ~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Invoke-ProcessTable], ParameterBindingException
    + FullyQualifiedErrorId : MissingMandatoryParameter,Microsoft.AnalysisServices.PowerShell.Cmdlets.ProcessTable

-Credential : The term '-Credential' is not recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:13 char:4
+             -Credential $AzureCred `
+             ~~~~~~~~~~~
    + CategoryInfo          : ObjectNotFound: (-Credential:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException

推荐答案

确保在执行脚本之前已安装支持的模块。

因为安装模块需要一些时间。

有关详细信息，请参阅"使用Azure自动化帐户自动化
Azure Analysis Service处理"。

For more details, refer "Automating Azure Analysis Service Processing using Azure Automation Account".

希望这会有所帮助。

这篇关于处理Azure Analysis Services的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！