Archive for the ‘PowerView SQL Server 2012’ Category

I am dissatisfied with Power View in Excel 2013.

First of all, it cannot connect to a multidimensional cube. See the error message below.

Powerview error to connect to multidimensional cube

Secondly, it is a cut down version of Power View in SharePoint. The charts or maps are not available for use.

Powerview ribbon in Excel 2013

Only table and tile are available (as shown below).

Power View in Excel 2013

If you ask me to choose, I will choose Power BI Designer Preview.

Update – I just managed to find out how to change the table to a chart (after searching on Google). The charts are available in the “Design” tab (not in the “PowerView” tab).  ~~~~ :_ {

Power View - Design tab

Read Full Post »

I installed Excel 2013, but can’t find PowerView.  It isn’t on the Ribbon, and it isn’t on the COM add-in list when I click File->Options->Add-Ins->COM Add-Ins(from dropdown)->Go…I could see PivotTable and Pivot Chart.

Excel 2013 ribbon

For some reasons, PowerView has not been added. To add it to the ribbon, go to File menu > Options > Customize Ribbon. Select “All Commands” then look for Power View in the drop down list as per screenshot below. Click Add.

Power View ribbon in Excel 2013

If you get a prompt to create a group because commands can only be added to custom groups. To create a group, pick a tab in the list then click New Group. I am not able to rename the new group.

Rename New Custom Group Excel 2013

Now I can see the Power View. 🙂

PowerView available Excel 2013

Read Full Post »

Microsoft has officially announced the availability of “Microsoft SQL Server 2012 With Power View For Multidimensional Models CTP”.

Downloadable from below. You must download all files below:

SQLFULL_x64_ENU_Core.box 2.0 GB  
SQLFULL_x64_ENU_Install.exe 88 KB  
SQLFULL_x64_ENU_Lang.box 702.8 MB


If you have an existing SQL Server 2012 already installed, make sure that you install this one using a named instance such as POWERVIEW_OLAP. You then have to create a new SQL Server Reporting Services Service Application in SharePoint before you can work with PowerView. Once created successfully, create a new report data source as below.

PowerView multidimensional report data source setup


PowerView Multidimensional

If  your existing powerview tabular report stops working, recreate the SQL Service Reporting Services Service Application thenremap the report data source.  It should work as it has with me. I can now use both PowerView tabular and multidimensional 🙂



Read Full Post »

I received this error when creating a report data source for PowerView.

My connection string is below.

Data Source Type is set to Microsoft BI Semantic Model for PowerView

Connection String is set to below:

Data Source=BIDEMOVM\SSASTABULAR; Initial Catalog=HelloWorkPicnic;

a connection redirector error


This error is very misleading. My SQL Browser service is confirmed running. So I double check my set up again and found out that my connection string was incorrect. It should be below. I have missed the number 2 there.

Data Source=BIDEMOVM2\SSASTABULAR; Initial Catalog=HelloWorkPicnic;


Read Full Post »

When I access my Picnic dashboard from my laptop, the  images of fruit, beverages, bread, and vegetable on my slider and tile container were not displayed. This is because the URL of these images were referencing to http://localhost. The following screenshot shows that the URL links have been referenced correctly.

Member value in SSAS Tabular

To point it to a server name, right click on the SSAS Tabular database then select “Script Database as” option followed by the ALTER TO” option to the new query editor window as per screenshot below. This will output the script in XMLA. Do a quick find and replace from http://localhost to http://bidemovm2, in my case. Then process the database.

How to modify ssas tabular


Read Full Post »

It took me 3 days to set this up correctly on my VM. Ensure that your VM has got at least 4 GB of RAM and 150 GB of disk space. PowerView is not a standalone application. You access PowerView from PowerPivot in Excel or the Report Shared Data Source (RSDS) within SharePoint.

PowerView - Picnic Items

My VM specification:

1. OS: Windows 2008R2 server Standard edition 64 bit with SP1 (evaluation copy)

2. SharePoint Server 2010 Enterprise edition 64 bit (with SharePoint Foundation Server 2010, SharePoint Foundation 2010 Language Pack SP1 and SharePoint Server 2010 SP1 ALL installed consecutively). SharePoint 2010 Server SP1 is required to support SQL Server 2012. Install prerequisites from the media, if fails, retry till successful.

Steps to set up PowerView:

1. Install SQL Server 2012 developer or enterprise edition. Install SP1 as well. This will require 8946 MB of disk space. Select all features EXCEPT SSRS – native. This is very important. SSRS must be configured as integrated mode.  Install SSAS multidimensional first. Once installation completes, re-run the media but this time install SSAS as TABULAR.  In this exercise, I have set my SSAS Tabular Instace name as SSASTABULAR. Tabular model represents your Dimensional model in a flattened table format.

ssas 2012 tabular

2. Go to my blog below to set up SSRS 2012 as integrated mode.


3. Grant NT AUTHORITY\Network Service sysadmin access to the database.

4. Configure PerformancePoint 2010 (OPTIONAL –  good to be configured correctly for future need):

– Create Secure Store Service Application Key.

– Create a local account on the server called SPServiceAccount. Grant this account access to the db (no need reader or writer access)

– Set up Unattended Service Account using SPServiceAccount.

5. Test PerformancePoint:

– Grant SPServiceAccount access to OLAP Cube as browser.

– Grant your account access to OLAP Cube as superuser.

– Test PerformancePoint by creating a data source to the OLAP Cube. Make sure that the connection is successful.

6. Install Silverlight 5, 64 bit as PowerView uses Silverlight 5 and above.

7. Activate PowerView on SharePoint.

    To Activate the Power View Feature

  1. Open your browser to the desired SharePoint site.
  2. Click Site Actions.
  3. Click Site Settings.
  4. Click Site Collection Features in the Site Collection Administration Group.
  5. Find Power View Integration Feature in the list.
  6. Click Activate.

8. Install Excel 2010 64 bit

9. Install PowerPivot for Excel 2010 64 bit

10. Install SSRS 2012 Add-In with SP1.

11. Install PowerPivot Add-In for SQL Server 2012

12. Install SQL Server PowerPivot for SharePoint from the media.

In summary, below is a list of the database server instances and SSAS 2012 server instances created on my VM:

my VM list of servers

NOTE!!! I followed the tutorial provided by Microsoft to create my first report in PowerView. I attempted MANY TIMES  to create PowerView report using the PowerPivot Excel spreadsheet as the data source as per tutorial but it has been failing on me with an error of  ” The remote server returned an error: (404) Not Found.”

Connection String is set up to below. Many Internet users reported having failure in configuring this!

Data Source=”http://bidemovm2/Documents/HelloWorldPicnicSQL2012/HelloWorldPicnicPowerViewRTM.xlsx”;

setting up powerview excel as report data source in powerview

So I resolved to restore it to my SSAS Tabular instance. I then used this as my report data source in PowerView.

Tutorial – http://msdn.microsoft.com/en-us/library/hh759325.aspx

Steps to restore SSAS TABULAR from PowerPivot:

1.Download the sample (i.e. PowerViewPowerPivotHelloWorldPicnicSamples.zip)  from the link below. This sample contains 3 files.


HelloWorldPicnic sample list

2. Copy the HelloWorldPicniPowerViewRTM Excel file to where the SSAS Tabular Backup folder location on the server.

3. Open SSMS then connect to SSAS. Set the server name as localhost\SSASTABULAR.

3. Right click on the databases then select the “Restore from PowerPivot” option.

Restore SSAS Tabular from PowerPivot

4.  Browse to the location of the Excel file previously copied in Step 2.

ssas tabular backup location

5. Restore set as below:

Restore from PowerPivot details

6. Refresh SSAS Tabular databases then browse the SSAS Tabular Model. It looks exactly like when you browse to the OLAP Cube.

ssas tabular browse look and feel

7. Done!

To create a report data source for PowerView:

1. Go to your SharePoint site.

2. Go to Library or Shared Documents.

3. Create a new document then select Report Data Source.

how to create a report data source for PowerView

4. In this example, configure as below:

Data Source Type  = Microsoft BI Semantic Model for PowerView

Connection String = Data Source=BIDEMOVM2\SSASTABULAR; Initial Catalog=HelloWorldPicnic;

HelloPicnicTabular RSDS

5. Test the connection. Once successful then click OK to create it.

6. Hover over your mouse to the right on the RSDS you just created then select the “Create PowerView Report” option.

Create PowerView Report from RSDS

7. This will pop up the PowerView window. The PowerView report extension is rdlx.


8. Follow the tutorial below to create Picnic dashboard in PowerView. 🙂

Tutorial – http://msdn.microsoft.com/en-us/library/hh759325.aspx

Have fun!

Read Full Post »

%d bloggers like this: