This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Best Approach to Refresh PowerPivote Data

Question
0

Sign in to vote

Hi Team,

I need to Refresh the PowerPoint data in SharePoint 2013.

Please let me know which is the best option to refresh the PowerPoint data.

I know, we can use "Manage PowerPivote Data Refresh", I would like to know the limitation of this approach.

Can I refresh the Excel file which is about 55 MB in Size?

Regards,

Vidya Lokesh

Monday, October 17, 2016 8:37 PM

Answers

1

Sign in to vote
Hi Vidya Lokesh,

I did not find any official article about the limitation of data refresh.

By default, 50 megabytes is the maximum file upload size for SharePoint web applications. And the maximum value that we can specify is 2 gigabytes.

Refer: Configure Maximum File Upload Size (Power Pivot for SharePoint)

https://msdn.microsoft.com/en-us/library/ff487972.aspx

The files under this size limitation could refresh well. An article about Power Pivot Data Refresh with SharePoint 2013.

https://msdn.microsoft.com/en-us/library/jj879294.aspx?f=255&MSPPError=-2147217396

Best Regards,

Linda Zhang
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com
- Proposed as answer by croute1 Tuesday, October 18, 2016 2:44 PM
- Marked as answer by Victoria Xia Tuesday, November 1, 2016 11:03 AM
Tuesday, October 18, 2016 5:27 AM