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.