Power View

How we can show in our last post one of the advantage of using a tabular model is the possibility of create reports using Power View.

Power View is a reporting services add-in for SharePoint and allows us to create reports and explore data in a rich interactive way without leaving SharePoint. How I said before Power view is reporting services add-in so will need to install Reporting Services integrated with SharePoint and configured properly (You can see how to do it in an early Post).

From a library that use the reporting services content types (In this case the Report Data Source content type), go to New Document and select Report Data Souce.

You will need to configure the connection string and credential information.


After created go to the context menu of the new connection file and choose Create Power View Report.


And that’s all, we now can see our designer interface and begin to create our reports.