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 -
A part of this is similar to what you mentioned. We do need to know whether we need to create a login for service principal within the AAS database or only giving the contributor access to the resource should be sufficient.
Also, we want to know whether there is a via scripting to override the existing login details in the cube in Azure with the help of runbooks. We are currently publishing the cube using our credentials via visual studio.