Forum Discussion
Lidou_Cand
6 years agoHelper III
Azure Analysis Service: Process Tabular Model with SSIS
Hello, I hope you are well. I know this is not the right place to discuss Azure Analysis Services but I have not found a forum for this product. I would like to process an Azure tabular model using S...
- 6 years agoHi there
Thanks for having a look into it.
What I have done is the following:
1. When creating the database connection I use a SQL account without any expiry on the account. This allows me to always be able to authenticate to the configuration database.
2. For connecting to the Azure AS to process the partitions, I have created a Service Principal which I then configured in Azure AS and within AsPartitionProcessing. I followed these steps to create and configure the Service Principal https://cloudblogs.microsoft.com/industry-blog/en-gb/cross-industry/2018/06/22/how-to-automate-processing-your-azure-analysis-services-models/
Lidou_Cand
6 years agoHelper III
GilbertQ
6 years agoSuper User
Thanks for letting us know it worked!