Skip to Main Content
PowerPivot for Business Intelligence Using Excel and SharePoint
book

PowerPivot for Business Intelligence Using Excel and SharePoint

by Barry Ralston
March 2011
Beginner to intermediate content levelBeginner to intermediate
302 pages
6h 57m
English
Apress
Content preview from PowerPivot for Business Intelligence Using Excel and SharePoint

Using PowerPivot As an SSRS Data Source

The flow of data from SSRS to PowerPivot can almost be reversed completely, by using PowerPivot as a data source for an SSRS report. PowerPivot for Excel solutions can be stored in locations that may be only occasionally attached to a network, and therefore would have unpredictable availability. Examples of these occasionally connected locations include external USB hard disks, flash “keychain” drives, and even local disk drives. In these cases, PowerPivot for Excel solutions are not supported as a data source for SSRS. This is not the case in a PowerPivot for SharePoint solution. Deployment to SharePoint ensures the data is online, available for network access, and therefore available for connection to ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

SharePoint 2016 User's Guide: Learning Microsoft's Business Collaboration Platform, Fifth Edition

Tony Smith

Publisher Resources

ISBN: 9781430233800Purchase book