Importing data from an SSRS Dataset to PowerPivot RRS feed

  • General discussion

  • I'm using SSRS 2008 R2 for reporting and have begun working with PowerPivot for Excel - very cool. To enable simplified AdHoc reporting, I expose to users a bunch of data sets that can be woven together using Report Builder. I'd like to import these datasets to PowerPivot since they are optimized for analysis instead of using the Export to Data Feed feature in a report which tends to bring many unwanted fields. Is there a way to "subscribe" to a dataset this way?

    Wednesday, March 16, 2011 11:15 PM

All replies