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):

http://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:


http://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:



http://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:



http://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

Virtual Machine Manager enables you to deploy and manage virtual machines across multiple hypervisor, including VMware ESX and ESXi hosts. The purpose of this post is to demonstrate how to add a VMware host from System Center Virtual Machine Manager. The process is rather easy and requires a few steps. This post assumes you have already setup your VMware environment including; VMware host and vCenter Server.  For this demonstration we will use ESXi 5.1.

First step is to add a VMware vCenter Server. In the navigation pane in VMM click on Fabric, Add Resources, click on VMware vCenter Server

Fill in the computer name of the vCenter server. You will need to create a RunAs account that has permission to logon the vCenter Server.

You will prompted with Importing a certificate. Click Import.

Following the import of the certificate the job windows will display as follow:

After you have added the vCenter Server, you will need to add the ESX host. Right-click on All hosts in the Fabric navigation pane, click Add VMware ESX hosts and Clusters.

You will need to provide a RunAs account that has permission on ESX host itself. This is usually the root account of the ESX host. Click Next

Select your ESX host and click next.

The job windows will appear indicating that ESX host is being added.

In the navigation, click on Fabric,  vCenter Server. Notice you will see the number of managed hosts. In our case, we only added one ESX host.

That’s all. In the following post I will demonstrate how to deploy virtual machines on our new managed ESX host through VMM.

In the meantime, you can find lots of information at the following link http://technet.microsoft.com/en-us/library/gg610683.aspx