Creating a Power View report via the PowerPivot gallery
Once you have PowerPivot data sources published to your PowerPivot gallery in SharePoint, they become linked to Power View, and you are able to create dashboards and reports from them. Users can be given access to the PowerPivot gallery directly, or they can be given links to the Power View report designer so that they are able to create their own ad-hoc reports at any time.
In the following recipe we will show how you can create Power View reports directly from the PowerPivot gallery.
How to do it...
To create a Power View report from the PowerPivot gallery, follow these steps:
Open the PowerPivot gallery and find the data source that you want to report off:
There are three icons on the top-right of the data source. The first will open up the data source in Excel, the second will allow you to create a Power View report from the data source, and the third allows you to define the refresh schedule of the data. For this example, click on the...