locked
PowerView in Excel 2013 without data RRS feed

  • Question

  • If we don't care about data refreshes, is there a way to build a Pivot table and/or Power View report off of Power Powerpivot WITHOUT having the PowerView model available to the users of the reports. 

    SharePoint is not an option, so we can't use the export to PowerPoint with interactive reports like PowerView can do in SharePoint.

    We would like Slicers and Filters to work, but we would prefer to not have them be able to change which fields are included in the reports.  Basically, a semi-read-only PivotTable or PowerPivot report.


    Ann Weber

    Tuesday, August 9, 2016 1:31 PM

Answers

  • This is not how Power Pivot was designed.

    The best way to accomplish this, is to use PowerBI.com, create a dashboard on top of your report, and share the dashboard. This way, the dashboard is read-only to the user although she can navigate to the underlying report(s) and interact with those.

    An alternative can be to first create your report (Power View and/or pivot tables), and after that hide all tables in the model. The views and pivots will keep working but the user will not see anything in the model. Obviously, this is not a secure solution as someone who knows how things work will be able to open the Power Pivot model (when you distribute the Excel file including the model), and a published model can be queried on all tables and columns with a reporting tool, if one knows what table names to use (and this can be derived from the views and pivot tables).

    • Marked as answer by Alwweb Wednesday, August 10, 2016 2:38 PM
    Wednesday, August 10, 2016 7:21 AM
    Answerer

All replies

  • This is not how Power Pivot was designed.

    The best way to accomplish this, is to use PowerBI.com, create a dashboard on top of your report, and share the dashboard. This way, the dashboard is read-only to the user although she can navigate to the underlying report(s) and interact with those.

    An alternative can be to first create your report (Power View and/or pivot tables), and after that hide all tables in the model. The views and pivots will keep working but the user will not see anything in the model. Obviously, this is not a secure solution as someone who knows how things work will be able to open the Power Pivot model (when you distribute the Excel file including the model), and a published model can be queried on all tables and columns with a reporting tool, if one knows what table names to use (and this can be derived from the views and pivot tables).

    • Marked as answer by Alwweb Wednesday, August 10, 2016 2:38 PM
    Wednesday, August 10, 2016 7:21 AM
    Answerer
  • Thank you so much!  I really appreciate the thorough answer.  I don't know why I didn't think about hiding every table. :)  Great work around, although not secure.


    Ann Weber

    Wednesday, August 10, 2016 2:40 PM