Integration services - connector to Azure Analysis Services

Question

Hi,

Is there any way how to load data from Azure Analysis Services to Azure SQL database? Previously, we used PowerQuery component in SSIS and it works if OLAP cube is on prem. When client switched connection to Azure, we are not able to load data from PowerQuery component to Azure SQL Server. It seems Azure Analysis Services requires MFA type connection, which works in PowerBI and Excel, but from Visual Studio we are not able to establish connection to Azure Analysis Services. Any ideas?

Answer 1

Hi @tommy crni ,

As far as I know, If you want to use Visual Studio to connect to AAS, you may need to use paid third-party plugins.

If you use SSIS in Azure Data Factory (ADF) and want to connect to Azure Analysis Services (AAS) instance, you can not use an account with Multi-Factor Authentication (MFA) enabled, but must use an account that does not require any interactivity/MFA or a service principal instead.

To use the latter, see here to create one and assign the server administrator role to it, then select Use a specific user name and password to log on to the server in your connection manager, and finally enter User name: app:YourApplicationID and Password: YourAuthorizationKey.

Reference: analysis-services-connection-manager

Regards，

Zoe

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October