Forum Discussion

palmpen's avatar
palmpen
Frequent Visitor
11 years ago

DataSource.Error: AnalysisServices: A connection cannot be made. Ensure that the server is running.

I am having problem connecting Power BI Desktop (v2.25.4095.554) in client laptop to SSAS Cube in the server (v2012 Enterprise Edition with SP2). I keep getting error message: "DataSource.Error: Anal...
Anonymous's avatar
Anonymous
Not applicable
11 years ago

palmpen

While you cannot "connect" to your cube in the way that you can a tabular model yet (recognizes and pulls in relationships etc) you can query your cube, and as of today MDX/DAX queries are supported in the August update of the Desktop. You can check it out here

  • palmpen's avatar
    palmpen
    Frequent Visitor
    11 years ago

    Thanks for the comments and suggestions.

    I still have the issue connecting Power BI Desktop (v2.25.4095.554) in client laptop to SSAS Cube in the server (v2012 Enterprise Edition with SP2). I keep getting error message: "DataSource.Error: AnalysisServices: A connection cannot be made. Ensure that the server is running". I tried 32 & 64 bit Power BI Desktop and the corresponding SQL_AS_ADOMD.msi.

    I can connect Excel in my laptop to the SSAS cube without problem.
    I am able to connect Power BI Desktop to the SQL Server DB (Relational) in the same server.

    I am not using Power BI Personal Gateway and SSAS Connector.
    I am not trying to connect to SSAS Tabular model, but just the SSAS Multidimensional Cube.

    Please give me some advice. Thank you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      11 years ago

      First - I recommend you download the latest Desktop version that I provided a link to in my first response. Current version number is 2.26.4128.403 (you need this version to write MDX/DAX.
      Second - you only have one option to select to connect to your cube, this one:

      Untitled.png

      If you can confirm the above is what you are doing, there may be issues related to location of the SSAS cube as it relates to domain and/or username or permissions..

       

       

       

      • palmpen's avatar
        palmpen
        Frequent Visitor
        11 years ago

        Yes, that's the one I use; "Select items and get data from Multidimensional or Tabular model".

        Btw, I have no issue connecting Excel to the SSAS Cube, I also test it with Tableau, and no issue.

Related content