Creating PowerView Dashboards from the PowerPivot Gallery Data Sources

The real benefit of hosting your PowerPivot workbooks within a PowerPivot Gallery is that people can then report off the data source as if it were a mini data warehouse using PowerView.


To create a PowerView dashboard from a PowerPivot data source, follow these steps:

  1. Within the PowerPivot Gallery, if you select a data source, you will be able to see three icons to the right of the selection. Click on the middle one that is captioned Create Power View Report to launch the PowerView report designer.


The gallery will be replaced with a PowerView Reporting Canvas with the fields from the PowerPivot being displayed as reporting fields.

You can build the PowerView dashboard through the web interface in just the same was as we built them from within Excel.

After you have created the dashboard, click on the File menu, and then select the Save As option to save your dashboard back to your PowerPivot Gallery.

All you need to do is save give your dashboard a name and click the Save button.

Now you will see the report that you generated within the PowerPivot Gallery alongside the PowerPivot Data Source.

Check out comprehensive Advanced Excel Reporting, Data Modeling ; Analytics with Microsoft Excel Power Pivot here

Happy Excelling
Team Excelgoodies

One thought on “Creating PowerView Dashboards from the PowerPivot Gallery Data Sources

Leave a Reply to Mircea Cancel reply

Your email address will not be published. Required fields are marked *