SQLAuthority News – Microsoft WhitePaper on PowerPivot Data Refresh

I was recently working at customer location on PowerPivot project. It was quite complected as this is relatively new technology and we all are exploring what this technology can do and what it can bring to us on table in real life experience. During this implementation the project design document needed specification regarding Data Refresh rates. It was a bit complected as there were various components and modules to the project and selecting the refresh rates means understand all of the requirement as well understanding our implementation in and out.

I referred following white paper from Microsoft before I move further in the project and found it very helpful and it helped me understand the implication of various data refresh methods and its capacities.

Everything You Always Wanted to Know About PowerPivot Data Refresh but Were Afraid to Ask

Following is the summary of the whitepaper.

The purpose of PowerPivot for SharePoint is to allow users to share their PowerPivot workbooks in a secure and scalable environment. To ensure that you are sharing and collaborating on the most recent data available to you, PowerPivot for SharePoint provides a data refresh feature that lets you automatically update PowerPivot data in an Excel workbook. This white paper describes in detail the data refresh feature in PowerPivot for SharePoint. It starts by explaining the steps for setting up a data refresh schedule in SharePoint, and then it continues with an in-depth view on how data refresh works on a SharePoint farm. Both administrators and the business analysts who author and manage PowerPivot workbook data can benefit from learning more about setting up and using data refresh in a SharePoint environment.

I suggest if you are facing situation like me download this whitepaper and read it before moving ahead in project.

Reference: Pinal Dave (https://blog.sqlauthority.com)


PowerPivot, SQL Download, SQL White Papers
Previous Post
SQL SERVER – 1500 Posts – A MileStone – Origin of Blog Name Revealed
Next Post
SQL SERVER – StreamInsight and SQL Server 2008 R2

Related Posts

3 Comments. Leave new

  • Hi Dev/Team,

    i have use this link

    Everything You Always Wanted to Know About PowerPivot Data Refresh but Were Afraid to Ask

    the document is downloaded but it is showing .docx

    in my pc i have ms office 2003 can you please guide me how can read all .docx documents

    Thanks & Regards

  • Great stuff, thanks. Do you use any other Microsoft products? My company used MS applications until about 2006 and then moven to UNIX. It took a lot to (3 years!) to get 100% and work to everyone’s needs but now it’s rock solid. Saved thousands on MS licencing! Thanks, Jam.


Leave a Reply