I am trying to run data mining query task in SSIS project in visual studio. Analysis service instance is running on azure cloud. I am trying to execute mdx query to retrieve data from AAS.
Connection to Azure Analysis Service is set up via Microsoft OLE DB Provider for Analysis Service 14.0
.
When task is executed, following error occurs:
Error: 0x0 at Data Mining Query Task: Failed to execute data mining query due to the following error: Could not load file or assembly 'Microsoft.AnalysisServices.AppLocal.AdomdClient, Version=14.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
Task failed: Data Mining Query Task
As per error description, I installed ADOMD drivers from here: https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers
How can I get past this error? Despite of installing ADOMD drives, Am I missing something regarding assembly it is trying to find?