O'Reilly logo

Excel Power Pivot and Power Query For Dummies by Michael Alexander

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required