Azure PowerShell函数应用报错：Timer输入绑定未定义参数

核心问题：param()块位置错误 #

你的脚本中param($Timer)不是脚本的第一个有效执行语句（前面有Import-Module SqlServer），这会导致Azure Functions PowerShell运行时无法识别该参数为绑定输入。在PowerShell脚本中，param()必须是注释和空行之后的第一行有效代码。

修复步骤 #

• 将param($Timer)移至脚本最顶部（仅保留注释和空行在其上方）
• 确保脚本编码为UTF-8无BOM（避免运行时解析错误）
• 验证function.json中的name值与param变量名完全一致（Linux环境下大小写敏感）

修正后的run.ps1代码 #

# Azure Functions Timer Trigger for AAS Refresh
param($Timer)

# Import required modules
Import-Module SqlServer

# Get the current universal time in the default string format
$currentUTCtime = (Get-Date).ToUniversalTime()

if ($Timer.IsPastDue) {
    Write-Host "PowerShell timer is running late!"
}

# Define your service principal
$tenantId = "tenantId"
$clientId = "clientId"
$clientSecret = ConvertTo-SecureString $env:clientSecret -AsPlainText -Force
$cred = New-Object System.Management.Automation.PSCredential($clientId, $clientSecret)

# Analysis Services details
$envUpper = $env:envUpper
$env = $envUpper.ToLower()
$analysisServicesServerPrefix = "myserverprefix"
$fullServerName = $analysisServicesServerPrefix + $env
$analysisServicesDatabase = "db"

try {
    # Authenticate with service principal
    Connect-AzAccount -ServicePrincipal -Credential $cred -Tenant $tenantId

    # Refresh the data model using Invoke-ProcessASDatabase
    Invoke-ProcessASDatabase -Server $fullServerName -DatabaseName $analysisServicesDatabase -RefreshType "Full"
} catch {
    # Write the error message and throw error
    Write-Error "Error occurred during data model refresh: $_"
    throw $_
}

# Write an information log with the current time
Write-Host "PowerShell timer trigger function ran! TIME: $currentUTCtime"

额外排查点 #

• 确认Azure Functions运行时版本为PowerShell 7.x（v4），旧版本可能存在参数解析差异
• 检查requirements.psd1中依赖模块是否正确配置，运行时会自动根据该文件下载对应版本模块
• 验证服务主体权限：确保其拥有Azure Analysis Services的Process Database权限

内容的提问来源于stack exchange，提问作者Muhammad Pathan