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 -