I have an Azure Analysis Services (AAS) instance with a tabular cube using Azure Active Directory (AAD) for authentication.
I also have an OnPrem SQL Server on a separate domain serving this AAS tabular cube.
(Integrating these 2 domains is not on the cards I'm afraid - IT has their reasons)
As I don't have an Azure SQL Server in place, I have to schedule the refresh of this cube from my OnPrem SQL Server.
In SSMS when connecting to the AAS instance, I can easily process the cube.
The SQL Agent job on my OnPrem server has a "SQL Server Analysis Services Command" step which I've set to Run As using a Proxy Account. this job fails with the following error summary:
"Executed as user: MyDomain\My.UserAccount
Authentication failed: User ID and Password are required when user interface is not available."
The issue undoubtedly is that my Proxy Account is setup using a Login/Credential from my OnPrem domain. There is no option to enter credentials from my Azure Active Directory.
Any suggestions on how I might go about scheduling the refresh of my AAS Tabular Cube either using SQL Agent to "push" the job, or possibly some alternate means in Azure to trigger a "pull" of the refresh?
