Authenticate Azure Blob Storage Account in cloud using a runbook

[srjss]

In AZURE ANALYSIS SERVICES Tabular model (with compatibility level 1400) I imported a Blob storage account as a Data Source. It's Authentication Kind is Key kind of authentication. The key is a Static Key.

But while refreshing the Tabular using a Runbook in Automation Account (Cloud PowerShell) is there a way to pass the key/credentials so that it could authenticate?

Otherwise the PowerShell fails with below message

The given credential is missing a required property. Data source kind: AzureBlobs. Authentication kind: Key. Property name: Key. The exception was raised by the IDbConnection interface.

Here is the Source definition copied from Model.bim file:

     {
      "createOrReplace": {
        "object": {
          "database": "azureanalysisservicesdatabase",
          "dataSource": "OMSLogs"
        },
        "dataSource": {
          "type": "structured",
          "name": "OMSLogs",
          "connectionDetails": {
            "protocol": "azure-blobs",
            "address": {
              "account": "storage",
              "domain": "blob.core.windows.net"
            },
            "authentication": null,
            "query": null
          },
          "credential": {
            "AuthenticationKind": "Key",
            "kind": "AzureBlobs",
            "path": "https://storage.blob.core.windows.net/",
            "PrivacySetting": "Organizational"
          }
        }
      }
    }

this is the code I ran in PowerShell to process the Database:

Invoke-ProcessASDatabase -databasename $DatabaseName -server $AnalysisServerName -RefreshType "Full" -Credential $SPCredential

[u02cm62]

why not just put it in the parameters of the runbook?  Then you key it in (copy/paste), when you schedule the runbook.

[v-xicai]

Hi @srjss ,

It seems the issue is about the Azure , I'd suggest you post this issue in the Azure Community Support forum for more professional help .

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.