Share via

How to connect to sql server analysis services cube using ADOMD.NET

Dharma Reddy Bojjireddy 0 Reputation points Microsoft External Staff
2023-08-11T19:50:43.4333333+00:00

We are trying to connect to the SSAS cube using either of the Azure services (ADF, Logic App, and Function App or Power Automate Flow). We copied the connection string from the Excel source and changed the Integrated Security = SSPI and used my User Id and password to connect. ADF we used Integrated runtime, Logic App we used OnPrem Gateway and function app we used ADOMD.NET. We failed to establish a connection. Any suggestions will be really helpful.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,338 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Javier Villegas 900 Reputation points MVP
    2023-08-11T20:25:54.6533333+00:00

    Hi @Dharma Reddy Bojjireddy

    Have a look to this document. this is the one I always use

    Connection string properties

    Regards

    Javier

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.