PBI connection to MS SQL using JDBC connection string

To rotate a key every 60 days in an Azure Function app using PowerShell, you can use the following script as an example:

```powershell
param($Timer)

$KeyVaultName = ""
$SecretName = ""
$RotationDays = 60

$currentDateTime = Get-Date
$keyRotationDateTime = Get-AzureKeyVaultSecret -VaultName $KeyVaultName -Name $SecretName | Select-Object -ExpandProperty Attributes | Select-Object -ExpandProperty Updated

# Convert the last rotation date to a DateTime object
$lastRotationDateTime = [DateTime]::Parse($keyRotationDateTime)

$daysSinceRotation = ($currentDateTime - $lastRotationDateTime). Days

if ($daysSinceRotation -ge $RotationDays) {
# Generate a new key value
$newKeyValue = New-Guid

# Update the key value in Azure Key Vault
Set-AzureKeyVaultSecret -VaultName $KeyVaultName -Name $SecretName -SecretValue $newKeyValue

Write-Host "Key has been rotated successfully."
} else {
Write-Host "No action required."
}
```

Ensure you have configured your Function app with a Timer trigger that triggers the script periodically. Adjust the values of `$KeyVaultName` and `$SecretName` with the appropriate names for your Key Vault and Secret.

The script checks the number of days that have passed since the last key rotation. If it exceeds the specified rotation period (60 days in this example), a new key is generated and updated in the Azure Key Vault. Otherwise, the script outputs that no action is required.

Remember to publish and configure your Azure Function app with the appropriate settings according to your requirements.