On the Quick Launch, click Site Contents, and then on the Site Contents page, click add an app to display the Your Apps page.

In the search box at the top of Your Apps page, type PowerPivot, and then click the magnifying glass at the right of the search box to locate the PowerPivot Gallery app. Alternatively, scroll down the page till you find the PowerPivot Gallery app.

Click the PowerPivot app to add a new PowerPivot Gallery on your site.

In the Adding PowerPivot Gallery dialog box, in the Name box, type the name for your new gallery, such as PowerPivot Gallery, and click Create.

You are taken back to the Site Contents page that now shows the new PowerPivot Gallery. You will now create a permanent link to this library on the Quick Launch. On the Quick Launch, below the list of links, click EDIT LINKS.

Drag the PowerPivot Gallery link up and position it above the Recent section, where it is currently located. Click Save on the Quick Launch to save the new Quick Launch layout.

On the Quick Launch, click the PowerPivot Gallery link to open it.

The new gallery is displayed. If Silverlight is not installed on your machine, the Install Microsoft Silverlight message box appears, prompting you to install Silverlight. Click the message box to download and install Silverlight on your computer.

In the download confirmation bar at the bottom of the screen, click Run to start the Silverlight installation.

Click Yes in the User Account Control message box, if it appears, to confirm that you’d like to allow the installation.

The Silverlight setup wizard starts. On the Install Silverlight wizard page, click Install now.

In the Installation Successful dialog, click Close, and then press F5 on the keyboard to refresh the PowerPivot Gallery page in the browser. This is the new gallery, so the page is empty.

You will now upload the SalesData workbook into the PowerPivot Gallery. Click the Files tab on the top left of the page to open the ribbon, and then in the New section, click Upload Document.

In the Add a document dialog, click Browse and go to the Chapter13 practice folder, select SalesData.xslx, and click Open. Then, in the Add a document dialog, click OK to upload the workbook. In the document properties dialog Power Pivot Gallery - SalesData.xslx (if it appears), click Save.

The workbook has been uploaded to the PowerPivot Gallery. It is displayed in the Gallery view that allows you to preview the worksheets within the workbook. The first worksheet is in focus and is displayed in the left pane, larger than the others. You can bring any worksheet in focus by pointing at it. You move to the worksheets that are not displayed in the screen by using the left and right navigation buttons, as well as by clicking the navigation dots, located at the bottom of the workbook view. Browse through the worksheets to familiarize yourself with the Gallery view of the workbook.

You will now explore other available PowerPivot Gallery views.

On the Library ribbon, in the Manage Views section, under Current View, open the drop-down list of views.

Select the Carousel view to switch to it. The workbook is displayed in the Carousel view, where you can browse through the worksheets using left and right arrows. The worksheet in focus is displayed in the center, whereas the worksheets to the left and to the right of it are dimmed. Use the left and right navigation buttons to go through the worksheets in the workbook.

Once again, on the Library ribbon, open the drop-down list of views, and this time select the Theater view. The worksheet in focus is displayed on top of the view, in the stage section. You can browse through the worksheets using left and right navigation buttons in the worksheets lineup under the stage, and you can bring them into focus on the stage by pointing at them.

Finally, open the drop-down list of views and switch to the All Documents view to display the library as the list of documents. This view can be useful for managing files in the library.

Switch back to the Gallery view that is the default view for all PowerPivot Galleries.

On the Quick Launch, click PowerPivot Gallery to open the PowerPivot Gallery, if it is not already open.

In the SalesData workbook displayed in the Gallery view, click the worksheet that you’d like to view; for example, Sales. Excel Services opens the workbook in the browser and displays the worksheet that you have chosen.

Explore the workbook. It contains five tables in five worksheets: Sales, Dates, Products, ProductCategories, Shops, and Locations. The worksheet tabs are shown at the bottom of the Excel Services page, as they would be in an Excel client.

The Sales worksheet lists sales transactions in Wide World Importers stores located in cities in the United States for the years 2011 and 2012. The Products worksheet lists assorted items of furniture that were sold during this period. Each product belongs to a product category. The product categories are listed in the ProductCategories worksheet. The Stores worksheet lists the Wide World Importers stores where the products were sold, and the Locations worksheet lists the cities and the states where the stores are located. Finally, the Dates worksheet is a reference table that provides a list of dates by the year, half year, quarter, and month.

After you have browsed through all the worksheets to familiarize yourself with the data, click the Sales tab at the bottom of the screen to return to the Sales worksheet.

You will now sort a Sales table by date in descending order. In the Date column header, click the down arrow to display a menu of sort and filter options, and then select Sort Descending.

The Sales table has been sorted in descending order by date. Notice that the button in the Date header now shows a down arrow that identifies that this column is sorted in descending order.

You will now display sales transactions from a Seattle store. There are one thousand transactions in the Sales worksheet, so locating specific transactions by scrolling through the table is difficult. It would be good to filter the table by Seattle store transactions. However, in the Sales table, the stores are identified by their numeric ID in the ShopID column, so first you need to find out the ShopID for the Wide World Importers shop in Seattle.

Open the Shops tab and locate the Seattle store in the ShopName column, and then look up its ID in the ShopID column. The ID for the Wide World Importers shop is 1.

Go back to the Sales table by clicking its tab. Click the down arrow in the ShopID column header, click Number Filters, and then select Equals. In the Custom Filter dialog, type 1, and then click OK.

The transactions with the ShopID of 1 are displayed. You will now locate a specific transaction in the displayed list of transactions. Click Find at the top of the worksheet page. To search for a transaction that took place on September 3, 2012, go to the Find dialog, and in the Find what box, type a date of September 3, 2012, in the data format used in your setup (for example, 9/3/2012), and then click OK.

The cell that contains the search term is identified by the green box around it, and its row is brought into view.

Having explored the workbook and the data that it contains, you will now close the Excel Services page. In the top-right corner of the workbook, to the right of your user name, click X to exit Excel Services and to return to the PowerPivot Gallery page.

Click File, and then select Options.

In the Excel Options dialog, select Add-ins.

In the Manage drop-down list, select COM Add-ins, and then click Go.

In the COM Add-ins dialog, select Microsoft Office PowerPivot for Excel 2013 from the list of available add-ins, and then click OK.

In Excel, validate that PowerPivot has been enabled by verifying that there is now a PowerPivot tab displayed on the ribbon.

Click File, select Open, click Computer, and then click Browse.

Go to the Chapter13 practice folder, select SalesData.xslx, and then click Open.

The SalesData workbook opens in Excel. You are already familiar with the tables in this workbook and the data they contain from the exercise in the previous section in this chapter. You will now open the data model in this workbook, and then explore and enhance it.

Click the PowerPivot tab on the ribbon, and then click the Manage button to open the PowerPivot window and to work with the data model.

The PowerPivot window opens in the Data View. In the View group on the ribbon, click Diagram View to display the diagram of the data model.

Explore the data model diagram that is displayed. It shows five tables in this workbook, with the names of the columns in each table and the links between the tables.

Point to an arrow that links the Sales table and the Shops table. The related columns in the linked tables are shown in blue boxes. Notice that the ShopID in the Sales table, which you had to look up in the Shops table in the previous exercise, is mapped to the ShopID in the Shops table so that the data can be retrieved without having to look it up manually.

Point to the link between the Sales table and the Dates table to see the related columns named Date. Point to the link between the Sales table and the Products table to see the related columns named ProductID. Finally, point to the link between the Products table and the ProductCategories table to see the related columns named ProductCategoryID.

You will now create a relationship between the Shops table and the Locations table using the LocationID columns, which both tables contain. Drag the LocationID column in the Shops table to the LocationID column in the Locations table. PowerPivot draws a line between the two columns, indicating that the relationship has been established.

You will now create a hierarchy of columns in the Dates table. It contains the columns for date, month, quarter, half year, and year. A date is a part of a month, which, in turn, is a part of a quarter, which, in turn, is a part of half of a year, which, in turn, is a part of a year. A hierarchy will establish these relationships between the columns. In the Dates table, hold down the Ctrl key while you click the Date, CalendarMonth, CalendarQuarter, CalendarHalfYear, and CalendarYear columns to select them.

Right-click one of the selected columns to open the context menu, and then select Create Hierarchy.

A parent hierarchy level is created at the bottom of the table, and the selected columns are copied under the hierarchy as child levels. Type Calendar to name your new hierarchy. Scroll down and resize the table box to view the entire new hierarchy.

You will now create another hierarchy in the Products table with the ProductCategory as the parent node, and ProductName as the child node. However, because the ProductCategory column is not a part of the Products table but of the ProductCategories table, you will first create a related ProductCategory column in the Products table, which will be calculated and filled in by the model. You can create a calculated column using Data View in the PowerPivot window.

In the View group on the ribbon, click Data View.

At the bottom of the Data View window, click the Products tab to display the Products table, and then click Add Column in the header row to the right of the table.

In the formula bar, type = RELATED(ProductCategories[ProductCategoryName]), and then press Enter on the keyboard. The RELATED function has returned values for each cell in the new column from the ProductCategoryName column in the ProductCategories related table. The new column has been populated.

To rename the new column from its default name, CalculatedColumn1, right-click the header of the new column, select Rename Column, and then type ProductCategory as the column name. Press Enter.

You will now use this column in a hierarchy in the Products table. In the View group on the ribbon, click Diagram View to display the data model diagram. Verify that the Products table now lists the ProductCategory calculated column that you have created.

In the Products table, hold down the Ctrl key while you click the ProductName and ProductCategory columns to select them, and then right-click one of the selected columns and select Create Hierarchy from the context menu.

Type Product Categories as the name of the new hierarchy.

In the top left of the PowerPivot window, click Save to save your data model. The PowerPivot window is minimized and the Excel workbook is displayed.

Open the Sales worksheet by clicking its tab at the bottom of the Excel window. Click the Insert tab on the ribbon, and then click the Pivot Table button.

In the Create PivotTable dialog box, under Choose the data that you want to analyze, select Use an external data source, and then click Choose Connection.

In the Existing Connections dialog box, on the Tables tab, under This Workbook Data Model, select Tables in Workbook Data Model, and then click Open.

In the Create PivotTable dialog box, under Choose where you want PivotTable report to be placed, verify that New Worksheet is selected, and then click OK.

The new worksheet opens and shows a PivotTable Fields list containing all the tables in the workbook data model. You will now create a PivotTable to analyze the SalesAmount by products and product categories and by dates and periods. You will use the Product Categories hierarchy for rows and the Calendar hierarchy for columns.

In the PivotTable Fields pane, expand the Dates table, and then drag the Calendar hierarchy into the Columns area. Expand the Products table and drag the Product Categories hierarchy into the Rows area.

Expand the Sales table, scroll down to the SalesAmount field, and drag it to the Values area. The PivotTable is built in the worksheet.

In the PivotTable, click Sum of SalesAmount in the top left of the table, and type Product Sales to change the title.

Click Row Labels and replace the text with Products. Click Column Labels and replace the text with Date.

Click anywhere within the PivotTable, and then click the Analyze tab on the ribbon. In the PivotTable Name box on the left of the ribbon, type Product Sales.

You will now add a PivotChart report. Position your cursor where you would like to create the PivotChart, click the Insert tab on the ribbon, click the PivotChart button, and then select PivotChart from the drop-down list.

In the Create PivotChart dialog box, under Choose the data that you want to analyze, select Use an external data source, and then click Choose Connection. In the Existing Connections dialog box, on the Tables tab, under This Workbook Data Model, select Tables in Workbook Data Model and click Open, and then click OK in the Create PivotChart dialog box.

In the PivotChart stencil, click the default title, Chart 1, and type Sales 2011-2012 to name the chart.

In the PivotChart Fields pane, expand the Dates table, and then drag the Calendar hierarchy into the Legend (Series) area. Expand the Products table, and then drag the Products Categories hierarchy into the Axis area. Finally, expand the Sales table, scroll down to the SalesAmount field, and then drag it to the Values area.

The PivotChart has been built in the worksheet. In the top left of the PivotChart, right-click the Sum of SalesAmount. Click on Value Field Settings. In the Value Field Settings dialog box, in the Custom Name box, change the name to Product Sales, and then click OK.

Click anywhere within the chart, and then click the Analyze tab on the ribbon. In the Chart Name box on the left of the ribbon, type Sales 2011-2012.

You will now prepare the workbook for publishing. Click the File tab, and then click Browser View Options to set up the parts of the workbook that will be visible on the SharePoint site.

In the Browser View Options dialog box, on the Show tab, in the drop-down list, select Items in the Workbook, and then select the Products Sales PivotTable. Select the Sales 2011-2012 chart from the list of available items, and then click OK.

Click the Save option on the menu at the left side of the screen to save your workbook, and then exit Excel.

In the browser, open the PowerPivot Gallery where you would like to publish your PowerPivot reports, if it is not already open. Click the Files tab, and then on the ribbon, click Upload Document.

In the Add a document dialog, click Browse and go to the location where you saved the SalesData workbook, such as the Chapter13 practice folder. Select SalesData.xslx, and then click Open. Then, in the Add a document dialog, click OK to upload the workbook. In the Power Pivot Gallery - SalesData.xslx document properties dialog (if it appears), click Save.

After the workbook has been uploaded, note from the preview that all worksheets are hidden from view. Only the PivotTable and the PivotChart are available, each on a separate page. Click the PivotTable preview page to open the dashboard in Excel Services.

You can analyze the data in the Products Sales table and drill down into the dates and the products using the plus and minus buttons, respectively, to expand and contract the sections. For example, expand the years 2011 and 2012 to display the sales amounts by the half-year periods. Then, expand the Chairs category to see the sales by individual products in this category, and further expand H1 2011 to display the sales of the Chairs products by month in Q2 2011.

Notice that there are options on the left of the page that allow you to save, download, or print the dashboard. You can also open the workbook in Excel for editing.

In the dashboard, you can browse between pages using their preview images in the View pane. Click on the preview image for the Sales 2011-2012 chart to display the chart page.

You will now analyze the Sales data using the chart. For example, double-click the Desks category, and then in the Query and Refresh Data confirmation message, click Yes to confirm that you would like to refresh the workbook, if it appears.

The chart is refreshed and displays the product sales in the Desks category by year.

You can choose a variety of product and date filter combinations by using the Product Categories drop-down list for the horizontal axis, and the Calendar drop-down list for the vertical axis. Try different combinations in the chart, if you want, and then exit Excel Services to return to the PowerPivot Gallery page.

Click the Settings gear icon, and then select Add a page.

In the Add a page dialog, in the New page name box, type My Dashboard, and then click Create. The new page opens for editing.

To insert the Web Part into the page, position your cursor within the box outlined on the page, and on the Insert tab, in the Parts group, click Web Part to display the Parts pane.

In the Categories list on the left of the page, select the Business Data category.

In the Parts list, select the Excel Web Access Web Part.

Click Add to add the Excel Web Access Web Part to the page.

On the My Dashboard page, in the Excel Web Access Web Part, click Click here to open the tool pane.

The tool pane for the Excel Web Access Web Part opens on the right of the page. In the Excel Web Access tool pane, in the Workbook Display section, at the right of the Workbook text box, click the ellipsis button.

In the Select an Asset dialog, browse to SalesData.xslx in the PowerPivot Gallery library, and click to select it. Notice that the URL for your selection is displayed in the Location (URL) box at the bottom of the dialog, and then click Insert. The URL has been inserted into the Workbook text box.

In the Excel Web Access tool pane, in the Workbook Display section, in the Named Item textbox, type Product Sales.

In the Toolbars and Title Bar section, in the Type of Toolbar list, select None.

Expand the Appearance section and set up the following parameters:

In the Excel Web Access tool pane, click OK to confirm your settings and close the tool. The Excel Web Part displays the Product Sales table.

On the Page tab, click Save to save the webpage. After the webpage has been saved, the ribbon closes and the webpage is displayed in browse mode. If there is a delay in displaying the PivotTable report, refresh the page.

You will now insert another Excel Web Part and set it up to display the PivotChart that you created in the previous exercise.

In the Settings menu, select Edit page. Using steps 3–13 as a guide, insert the second Excel Web Part. Type Sales 2011-1012 in the Named Item box in step 10.

On the Page tab, click Save to save your new My Dashboard webpage. After the webpage has been saved, the ribbon closes and the webpage is displayed in browse mode. If there is a delay in displaying the PivotTable and PivotChart reports, refresh the page.

Verify that the interactive capabilities are available within the Web Parts. For example, in the PivotTable, expand the year 2012, and then expand the Desks product category.

On the Quick Launch, open the PowerPivot Gallery with the SalesData workbook, if it is not already open.

In the top-right corner of the SalesData workbook gallery view, click the Create Power View Report icon to open its data model in the Power View design environment, and then create a Power View report.

Explore the Power View design environment. The main part of the page displays the view area, which is empty for the time being. In the view area, there is a design surface to create a new view, and the Filters area, which displays the filters in the view. To the right of the page, a Fields List area shows all the tables in the data model. You can drag the tables and filters to the view, or select the fields to appear there.

You will now create a table with the data for your visualization.

In the Fields List, open the Sales table, and then drag the SalesAmount field to the design surface in the view. Power View draws the table in the view, displaying actual data and adding a SalesAmount column heading.

In the Fields List, open the Locations table and drag the CityName field to the SalesAmount table in the view. When the table area becomes highlighted, release the mouse to add the CityName field to the table. Power View calculates the data and displays a new table with two columns: SalesAmount and CityName.

On the Design tab on the ribbon, in the Visualizations group, select Map. If a privacy warning appears in the yellow bar under the ribbon, stating that some of the data needs to be geocoded by sending it to Bing, click Enable Content to confirm that you would like to proceed.

A map visualization appears in the view. Resize the visualization area by dragging its corner so that you can see the map with the blue circles, the size of which indicates the sales performance for the individual stores.

While this visualization is already quite informative, you can bring even more insights to your map visualization with only a few clicks. You will now replace the blue circles with pie charts that will not only indicate the sales performance of a store, but will also show the sales by product categories.

In the Field List, open the ProductCategories table and drag the ProductCategoryName field into the Color area, located at the bottom of the Field List pane.

The map is redisplayed with the pie charts for each store location. In addition, a legend appears on the top right of the map. It lists the product categories, with the colors that identify them, in the pie charts.

On top of the map, click within the title area and type Sales Performance. To make it easier to interact with your report, switch to reading mode by clicking the Home tab, and then selecting Reading Mode in the Display group.

The map visualization is displayed in reading mode. Hover over the map to display map controls in the top-right corner of the map window. The controls allow you to adjust the map view by zooming in or out and moving the map up, down, to the right, or to the left. You can also drag the map within the window to bring different areas into view.

Point to a chart on the map. The chart increases in size and the mouse tip appears, showing the location of the shop, the name of the product category you happen to point to on the chart, and the sales amount for this category.

To call out a particular product category, click this category in the legend; for example, Tables. The colors for other categories in the pie charts are dimmed, allowing the sales performance for the Tables category to stand out and to be easily identifiable for all locations.

You will now work with the filters that are displayed in the Filters area. If the Filters area is empty, click the funnel icon in the top-right corner of the chart area to display the available filters in the Filters area. Open the CityName filter and select a city; for example, Boston. The report is filtered by the city name, Boston, and only the chart for Boston store is displayed on the map, allowing you to focus on the sales performance for this particular location.

Open the CityName filter again and clear the selection for Boston to redisplay the map with the sales performance charts for all stores.

Click Edit Report to return to the design mode, and then on the File menu, click Save As to save the Power View report to the PowerPivot Gallery. In the Save As dialog box, type SalesPerformance and click Save.

Click the Back button in the top-left corner of the browser window to return to the PowerPivot Gallery. Verify that the SalesPerformance report is saved in the gallery and that the preview image of the map visualization is shown.

On the Quick Launch, open the PowerPivot Gallery with the SalesPerformance report, if it is not already open, and then click the SalesPerformance preview image to open the report in the Power View design environment.

Click Edit Report, and then on the Home tab on the ribbon, in the Insert group, click New View to add a new view page. Power View creates an empty view. Notice that the View pane on the left of the screen has expanded to show the preview images for both views. Click the small left arrow icon on the top left of the View pane to hide it, so that you have more space to work with the visualizations in the view.

To build a table that will provide a basis for your pie chart visualization, in the Fields List, open the Sales table, locate the SalesAmount field, and then drag it to the view. Power View creates a table with the SalesAmount table heading and the actual value displayed.

In the Fields List, open the ProductCategories table, locate the ProductCategoryName field, and then drag it to the SalesAmount table in the view. When the table is highlighted, release the mouse to add the field to the table. Power View calculates the data and displays a new table with two columns: SalesAmount and ProductCategotyName.

On the Design tab on the ribbon, in the Vizualizations group, open a drop-down list of available virtualizations. In the Charts section, click Pie. Power View creates a pie chart that shows the product category sales.

To slice the pie sectors by a year, in the Fields List, open the Dates table, locate the CalendarYear field, and then drag it to the Slices area on the bottom of the Field List pane.

To build a table that will provide a basis for the bar chart visualization, in the Fields List, open the Sales table, locate the SalesAmount field, and then drag it to an empty area in the view. Power View creates a table with the SalesAmount table heading and the actual value displayed.

In the Fields List, open the Products table, locate the ProductMaterial field and drag it to the SalesAmount table in the view. When the table is highlighted, drag the field. Power View calculates the data and displays a new table with two columns: SalesAmount and ProductMaterial.

On the Design tab on the ribbon, in the Visualizations group, open a drop-down list of available visualizations. In the Charts section, click Bar. Power View creates a bar chart that shows the sales amount by product material.

On the top of the view, in the title area, type Sales Comparison.

In the bar chart, click a bar for a material; for example, Oak. Other bars in the bar chart become dimmed. The pie chart displays only the parts that apply to the Oak furniture, with the other parts dimmed. You have filtered one visualization (the pie chart) based on the selection in another virtualization (the bar chart) in the same view.

Expand the View pane to see the preview images for both views, and click on the first view to display it. Verify that the visualization in the first view is unchanged and displays the pie chart diagrams for all product materials, with no highlights. In other words, the first view has not been affected by the ProductMaterial filter in the second view.

Switch to reading mode by clicking Reading Mode on the Home tab on the ribbon, and then click the view chooser icon, in the bottom-left corner of the page, to display the row of clickable preview images at the bottom of the Power View window, which provides the navigation capability in the report.

The preview images are highlighted, whereas the rest of the screen is dimmed. When you point to a preview image, it is displayed in the main page area that is dimmed. When you click the preview image, its corresponding view is displayed in the full page, which is no longer dimmed, and the row of preview images is removed from display.

Close the Filters pane to provide more space for visualizations.

Click Edit Report, and then on the File menu, click Save to save the Power View report to the PowerPivot Gallery. Alternatively, you can click the Save icon on the top left of the page. If a Confirm Save dialog appears, click Save.

Click the Back button in the top-left corner of the browser window to return to the PowerPivot Gallery. Verify that the SalesPerformance report is saved in the gallery and that the preview images of both views are shown.

Click the Settings menu in the top right of your SharePoint page, and then select Add a page from the menu.

In the Add a page dialog, in the New name box, type Hello World, and then click Create.

The new page opens for editing. To insert the Web Part into the page, position your cursor within the box outlined on the page, and click the Insert tab on the ribbon. Then, in the Parts group, click Web Part to display the Parts pane.

In the Categories list on the left of the page, select the Media and Content category.

In the Parts list, select the Page Viewer Web Part.

Click Add to add the Page Viewer Web Part to the page.

On the Hello World page, in the Page Viewer Web Part, click open the tool pane. If a message box appears, asking you to save your changes before continuing, click OK.

The tool pane for the Page Viewer Web Part opens on the right side of the page. The next task is to specify the URL of the Power View report in the Link box in the Page Viewer tool pane.

To identify the report URL, open a new tab or a new window in the browser, go to PowerPivot Gallery, where the Power View report is located, and click a preview image to open the Power View environment.

In the Power View environment, set up the view in a way that you would like it to appear in the Web Part. On the Home tab on the ribbon, click Reading Mode to switch to the presentation mode so that the ribbon and other design tools are not displayed. In the multiple page reports, display the view that you want to be displayed in the Web Part when it first appears on the page; for example, the map visualization in the SalesPerformance report. Then, in the browser address bar, highlight the URL to select it, right-click the selection, and then click Copy on the context menu.

Return to the browser that displays the Hello World page, with the Page Viewer tool pane open on the right side of the page. In the Page Viewer tool pane, on the right side of the Link text box, click the ellipsis button to open the Text Editor dialog box, in which you can edit the URL.

Clear any text in the Text Editor dialog box, and then paste the Power View report URL into the Text Editor by right-clicking in the text box and selecting Paste from the menu.

In our scenario, the URL is as follows:

http://wideworldimporters/_layouts/15/ReportServer/AdHocReportDesigner.aspx?RelativeReportUrl=%2fwideworldimporters%2fPowerPivot%2520Gallery%2fSalesPerformance.rdlx&ViewMode=Presentation&ReportSection=ReportSection.

In your environment, the server path part of the URL will be different from the wideworldimporters. However, the rest of the URL will be similar because it is programmatically generated by SharePoint.

You will now add a parameter to the URL that will instruct the Power View to hide the top toolbar that displays the Edit Report and the Full Screen options, as well as the File menu. Unless you want users to edit the report from within the Web Part, hiding the toolbar will provide a better user experience.

In the Text Editor window, position your cursor at the end of the URL, immediately after ReportSection parameter, and type the following string: &PreviewBar=False.

The URL looks like the following, as long as you replace wideworldimporters with your server path as before:

http://wideworldimporters/_layouts/15/ReportServer/AdHocReportDesigner.aspx?RelativeReportUrl=%2fwideworldimporters%2fPowerPivot%2520Gallery%2fSalesPerformance.rdlx&ViewMode=Presentation&ReportSection=ReportSection&PreviewBar=False.

Click OK to insert the URL string into the Link text box in the Page Viewer tool pane, and then click Test link, located just above the Link text box. The link is tested in the new browser tab. Validate that the Power View report successfully opens. If the Power View report is not rendering, check the URL and repeat steps 9–13, if necessary.

Click the browser tab that is displaying the Hello World page, and then in the Page Viewer tool pane, in the Appearance section, set the following parameters:

In the Page Viewer tool pane, click OK to confirm your settings and close the tool.

On the Format Text tab on the ribbon, in the Edit group, click Save to save your new Hello World webpage. After the webpage has been saved, the ribbon closes and the webpage is displayed in browse mode. If there is a delay in displaying the Power View report, refresh the page.

In the Power View report, verify that the interactive capabilities are available within the Web Part. For example, in the Sales Performance view, point to a pie chart and verify that the mouse tip provides information about the sales performance of a product category in the location that you are pointing at.

In the bottom left of the Power View report, click the view chooser icon. Go to the Sales Comparison view and click a bar in the bar chart to filter the pie chart by product category.