What happens when you run a Data Refresh within #PowerPivot for SharePoint?

I was just recently asked the question by a fellow Analysis Services expert (Greg Galloway):

When you have SharePoint automate a data refresh for a PowerPivot workbook, is the new data saved back into the xlsx? So if I download the xlsx onto my laptop the next day, will I see fresh data? Also, if the xlsx is updated by SharePoint during data refresh, is that step subject to the 2GB file limit?

and I thought it made sense if that we share this answer as well.

So the answer is “Yes”.

…

Details you ask? Okay, here are the basic constructs:

Read more…

About dennyglee

dork, scribe, geek, Microsoft data dork, ultimate frisbee fan, mountain climber (barely!),... occasionally awake

View all posts by dennyglee →

Leave a Reply Cancel reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Cancel

Connecting to %s

Notify me of follow-up comments via email.