Forum Discussion

srjss's avatar
srjss
New Member
7 years ago

Authenticate Azure Blob Storage Account in cloud using a runbook

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

 

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

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