Unable to connect to SSAS Data source (via http access - msmdpump.dll) using Excel

Komal Sahu 311 Reputation points
2020-09-23T01:46:12.67+00:00

Hi ALL,

I am still facing issue posted in original post here..
If you can please help?

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,284 questions
0 comments No comments
{count} votes

Accepted answer
  1. Lukas Yu -MSFT 5,821 Reputation points
    2020-09-23T08:09:23.767+00:00

    Hi,

    It was an old post from last month , what is the current issue you are facing ? You could paste and post you current issue here.

    From you last post in MSDN seems that , the dll file is not installed in the control pane - program. It should be copy and paste in your end point web server. See here : Step 1

    Also I suggest you to follow the Configure HTTP Access to Analysis Services on IIS 8.0 This has been working as guide, normally we would not have problems.

    Regards,
    Lukas


    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.


1 additional answer

Sort by: Most helpful
  1. Olaf Helper 44,501 Reputation points
    2020-09-23T07:09:33.41+00:00

    Have you done all configuration steps mentioned on Configure HTTP Access to Analysis Services on IIS 8.0?

    1 person found this answer helpful.
    0 comments No 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.