cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srjss
New Member

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 2
u02cm62
Resolver I
Resolver I

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
Community Support
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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors