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

Consuming SSRS As a PowerPivot Data Source

In order to use SQL Server Reporting Services as a data source for PowerPivot, the first thing we need is a SQL Server Reporting Services report. For the example to follow, I'm using the SQL Server 2008 sample databases available from www.codeplex.com. We're going to use a very simple report from the AdventureWorks database. The report stored as a report definition language file or RDL file is available in the book's example download file.

Verifying Report Access

First we need to verify that we can actually access SQL Server Reporting Services. Troubleshooting connections among business intelligence products can be troublesome. It'll save time to verify access and connectivity up front. For this chapter's ...

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