Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 SSIS but I am experiencing connection difficulties in SSIS. I think it should have a configuration to do in Azure Active Directory. Anyone have an idea on how to do this? A tutorial would help me a lot. Thank you
Solved! Go to Solution.
Hello @GilbertQ
Thank you for your help.
I will test the Christian Wade's AsPartitionProcessing.
Have you ever used it in a production environnment ?
Hello @GilbertQ
I hope you are doing well.
Hello,
This weekend I looked at Christian Wade's AsPartition solution.
I tried using it locally but encountered some implementation issues due to Active Directory rights.
Speaking of which, I think you have a lot of experience with Azure AS.
In the project I am working on, our data source is a SQL Server On Premise database.
On a therefore set up a data gateway to connect us to our Azure Analysis Service server.
I would like to have your opinion concerning the impersonal account to process the model.
I encounter security difficulties to process the cube with the MFA set up by the company.
- Should we create a special login - password account especially for the model process?
- Should we instead create Application Service Principal to process the model? If so, is it complicated to set it up?
From your experience, what is your opinion?
Hello,
Thank you for your help.
I will see test this solution.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.