Automate analysis services cube refresh using service principal

Swathi Sudheer 1 Reputation point

We are using azure automation account to refresh our cubes but when we view the query sessions we see the queries using our login id's in the database. We want to use the service principal account to refresh the cube via azure automation account. Is there a way to override the credentials used to publish the cubes using power shell commands or scripts or do we have to do this manually by publishing the cube with the service principal account? Also, do we need to create a database login for the service principal account so it can be used to process and publish the cube?

We are using this command in our daily refresh runbook -
Invoke-ProcessASDatabase -DatabaseName

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
394 questions
Azure Automation
Azure Automation
An Azure service that is used to automate, configure, and install updates across hybrid environments.
937 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 25,461 Reputation points MVP

    For any deployment/updates over AAS, we need to provide admin access on server to a service principal

    You can update the datasource details by executing TMSL scripts on the basis of powershell