Power View with Office 2013


Today I got a chance to play around with the Power View in Excel. Yes. Excel but its Office 2013. You can also download office 2013 from here. It’s a consumer preview.

After installation if you won’t be able to find the Power view tab, please check the below step.

Go to File option and click on Options

Go to Add-In go to Manage. Click on COM Add-ins and click on GO

Select Power View and click on OK.

Once done. Let’s create a model and see how it can be used.

Click on Data Tab. Select From other sources and click on From Analysis Services.

I am trying it on tabular model however you can check with other sources. For more information about the tabular model please refer here.

Provide the Server Name and Log on credentials. Click Next

 

Select the Database and cube or table. Click Next

Click on Finish on last step.

Once you click on Finish. Voillaaaaa… you will get the new option to represent the data in Power View

 

Select the option and Click OK.

Comments (2)

  1. I am trying to connect the power view but it gives the following error.

    Sorry, Power View couldn't load the model or data source 'tblhyd002 PowerView Adventure Works DW' because the data source type is not supported. Please try connecting to a supported data model.

    Can you please help me regarding this issue.

  2. Sudhir says:

    Hi Surendra,

    Are you connecting to tabular Model ?

    Thanks,

    Sudhir

Skip to main content