Installing Power View for Multidimensional Models

Bradley Schacht

Bradley Schacht is a Cloud Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

9 Responses

  1. sam says:

    i am getting the following message: “A connection cannot be made. Ensure that the server is running” i can connect .

    I’m running sharepoint 2013 on the same box with sql 2012 sp 1 (11.0.3368) and that’s my connection string:
    Data source=;initial catalog=HR-EE;cube=’hr’

    any ideas.

    • Did you make sure to add the server name into the connection string after data source? I know it’s missing in the comment just wanted to be sure that you have it in there on the actual connection.

  2. Nutan Patel says:

    hi,, i have downloaded and installed 464142_intl_x64_zip.exe. after extracting file i didn t get
    file named “SQLServer2012-KB2833645-x64-PowerViewForMultidimensional.exe”. the was different. i have successfully installed that update but i am getting this error “Discover CSDL is not allowed on a server working in OLAP mode.”. Can you please me out?

    • Did you make sure to apply the update to your SSAS instance as well? The update must be applied to both Analysis Services and Reporting Services.

      • Dorsaf Mouhli says:

        I had the same error but the problem is that I can’t apply the file named “SQLServer2012-KB2833645-x64-PowerViewForMultidimensional.exe” but only on the powerpivot instance

  3. Bradley, what a great article. Congrats. Thanks a lot for your effort writing this post. The information is so useful if anybody wants to know what can and what can’t do with PowerView. I am a newbie in the subject, and now I understand I can use PowerView without necessity of installing SharePoint if I want to access my OLAP data sources: Multidimensional or Tabular.

    Obviously, you lost a lot of functionality if you don’t use SharePoint (Libraries, collaboration, gallery), but for those who can’t afford to buy the SP license, it is possible to consume data available in an Analysis Services tabular instance directly from PowerView or data available in Analysis Services multidimensional instance through PowerPivot. In both cases, you can also create a tabular model with data from diverse sources and then use it from PowerView.

  4. snap says:

    My understanding is that this works the way it does because it works *THROUGH* a reporting services reporting object in SharePoint (yikes!). This is supposed to ‘tabularize’ the results so PowerView can consume the output. What a slow, clumsy work around from MSFT.

  1. January 24, 2014

    […] 17. Install SQL Server 2012 CU4+ for Power View on Multi-dimensional Models DAXMD TIP! Bradley Schact has a nice blog on this step. […]

  2. February 24, 2014

    […] 17. Install SQL Server 2012 CU4+ for Power View on Multi-dimensional Models DAXMD TIP! Bradley Schact has a nice blog on this step. […]

Leave a Reply