Forum Discussion
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...
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:
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..
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.