Database Reference
In-Depth Information
Alternatively, you can share your own reports and people can view them
if given the right access. These Power View reports could have potentially
been included in the Excel file with the PowerPivot data model already, they
could be in a separate Excel file like the one we created in the exercises in this
chapter against the Tabular Analysis Services model, or they could be created
and saved directly in SharePoint. If they are included in the Excel file, you can
follow the steps just listed to save them to SharePoint.
Now that the file is in SharePoint, users have the ability to connect to that file
from their desktops in a new Excel file and create reports from it. In addition,
users could also create connection files in SharePoint that could in turn be
used to develop Power View reports from directly in SharePoint, or even use
them as sources for PerformancePoint dashboards.
Saving your Power View reports in SharePoint
If you are creating the Power View reports directly in SharePoint instead of Excel,
you can quickly save and share the reports directly in a document library. Once
the files are in the document library or possibly a PowerPivot Gallery, then you can
provide access to these reports for others to reference and explore. The following
are the steps that you can use to save a Power View report directly in SharePoint.
1.
After you have created your Power View report in SharePoint, select the
File tab in the Ribbon.
2.
Then click Save (or Save As; since this is your first time saving the report
those options will act the same) and enter a file name for the report file,
which has a file extension of RDLX, as shown in Figure 6-15.
FI g u R e 6 -15
Save a Power View report in SharePoint
