Share via


Upgrading your SQL Server 2012 to use Power View for Multidimensional

Hi,

If anyone is interested to upgrade his VM to be SQL Server 2012 SP1 CU4 to be
able to use the PowerView for OLAP.

I encountered several issues so below is the safe path J

1- First check your SQL Server 2012 version: (Very Important as I didn’t notice
and it costs me lots of time)

The easiest way to check is “select @@version” in BIDS

2- If not SP1 then install the SP1 update (below is the link for x64 sql server
only):

https://www.microsoft.com/en-us/download/details.aspx?id=3557…

File Name: SQLServer2012SP1-KB2674319-x64-ENU.exe

For other scenarios please check the below link:

https://technet.microsoft.com/en-us/library/jj200106(v=sql.15…

3- Then Ensure the SP1 is successfully installed by running the same query (1)
in BIDS

4- Now to install the Cumulative Update 4, you will download the first option
from the below link:

https://support.microsoft.com/hotfix/KBHotfix.aspx?kbnum=2833…

this one:

SQL Server 2012 All (Global) x64 SQLServer2012_SP1_CU4_2833645_11_0_3368_x64

5- Then create a data connection “Report data source” and choose "Microsoft BI Semantic Model for Power View"

6- You can use windows credentials and if it doesn’t work then create role and
assign user with full admin capabilities in the Role section of the project
from SSAS and check the “windows credentials” box.

7- Now just click on the new connection and will work.

Side Notes:

Once you finish you will notice that DQS and MDS doesn’t work:

Please read the below link and it will resolve your issues:

https://blogs.msdn.com/b/pfebi/archive/2012/11/20/what-happen…

hope this helps,

Best Regards,

Mahmoud El-Wessimy (Center of Expertise) | Technology Solution Specialist |
Data Platform |Microsoft Corporation