Chapter 7

Publishing Power Pivot to SharePoint

In This Chapter

arrow Understanding SharePoint and Excel Services

arrow Publishing an Excel workbook to SharePoint

arrow Using the Power Pivot Gallery

arrow Refreshing Power Pivot data connections

By publishing your Excel reports and dashboards to SharePoint, you can make them available to others in your organization via a browser and prevent multiple users from having separate versions of your workbooks on their computers. You can also make your Power Pivot reports easier to find, share, and use.

In this chapter, you first discover how SharePoint helps organizations share and collaborate on data. You will then explore the options for publishing your Power Pivot reports to SharePoint.

Understanding SharePoint

SharePoint is Microsoft’s premier collaborative server environment, providing tools for sharing documents and data across various organizations within a company’s network.

Typically deployed on a company’s network as a series of intranet sites, SharePoint lets various departments control their own security, workgroups, documents, and data. As with ...

Get Excel Power Pivot and Power Query For Dummies now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.