Yes, it is totally possible to publish a SSRS report into your PowerPivot Gallery – In fact, the gallery invites you to do so with the “New Report Builder Report” item in the PowerPivot gallery’s silverlight application.
But as my buddy George Orwell might say, “All reports are equal, but some reports are more equal than others.”
Essentially, you’re not going to get a snapshot generated for your SSRS reports stored here.
The status message displayed can be somewhat confusing, too: “Snapshots were disabled to protect sensitive content” is dead on the money, but infers there might be a way to enable this sensitive content. Don’t waste your time looking for the magic property to enable dynamic SSRS snapshots, however. No such animal.
The “Snapshots were disabled” message is used in a number of situations where connections in a xlsx published to the gallery aren’t quite right, and I guess we chose to lump the SSRS scenario in with them.
SO, how to deal with it ? no way ?
Nope. no way. I’ve gotten into a habit of publishing my Excel Services and SSRS reports to one library and keeping only my PowerPivot workbooks in the PowerPivot library.
At least for PowerPivot for SharePoint that came with SQL2008 R2, RDL files in the PowerPivot Gallery which use a PowerPivot workbook in that same doc libary as a data source do in fact get snapshotted. It’s only RDL files from RDLs that use other data sources that don’t get a thumbnail.