MEA Center of Expertise

We are a 120+ technology enthusiasts helping Microsoft customers around Middle-East & Africa region. We bridge Microsoft tools & technologies to their businesses.

Can i edit my PowerView Report exported to PowerPoint in Presentation Mode? YES YOU CAN

Can i edit my PowerView Report exported to PowerPoint in Presentation Mode? YES YOU CAN

  • Comments 4
  • Likes

with the release of SQL Server 2012 different versions until the RTM last week. Microsoft introduced a one kicking feature in the Business Insight Pillar with the new Amazing easy-to-use reporting PowerPivot that you can simply export this report to PowerPoint and when your slides are running the report can start being interactive.

well not only this. you can even turn you report to be editable so you can start creating some charts and do ad-hoc analysis within your presentation. so how can I do this let have a look

1. A key thing you need to know is that when you export your PowerPivot Report to PowerPoint the object that is exported is connecting to the report on the Sharepoint not connecting to the datasource of the Report. something like this

PowerViewFlowExample

2.  So after you export your Report to the PowerPoint right click on the object in the slide and click properties and in the InitParams scroll to the end and change AllowEditViewMode and set it to True

PVinPPS

3. when you present your slide Deck you’ll be able to do edit the report and start dragging and dropping same experience as the Web One.

PVinPPS2

PowerPivot is an amazing experience for Personal BI and demonstrating how easy and a flexible tool it’s to quickly get up from a database to an interactive editable report inside a presentation

 Manually modifying the InitParams or any of the Silverlight control properties is not an officially supported scenario. See msdn.microsoft.com/.../hh759323(v=sql.110).aspx. Thank you Riccardo Muti for the Heads-up

Comments
  • I believe in the post you mean Power View instead of PowerPoint. I know it is kind of easy to mix up at times and there is a space in the name.

  • See how easy it is to mess this up.  I meant Power View instead of PowerPivot:)  I was too focused on the edit capabilities in PowerPoint...

  • Note that manually modifying the InitParams or any of the Silverlight control properties is not an officially supported scenario. See msdn.microsoft.com/.../hh759323(v=sql.110).aspx.

  • Thanks Wagdi for the post. Really useful stuff.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment