Sharepoint Power View's Excel file can't be larger than 200 MB? RRS feed

  • Question

  • I have been playing around with Power View on Sharepoint after working with it in Excel 2013. There is an Excel file containing the data model that I uploaded to the PowerPivot Gallery. It used to work just fine, but after making some additions to the Data Model through Excel's Power Pivot, I re-uploaded the file to Sharepoint, but now when opening the Power View report, it gave me an error.
        An error occurred while loading the model for the item or data source 'http://<myserver>/PowerPivot%20Gallery/MDB%20Power%20View.xlsx'. Verify that the connection information is correct and that you have permissions to access the data source.
    I have no idea how this happened. The error details were
        <detail><ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsCannotRetrieveModel</ErrorCode><HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus><Message xmlns="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://win-hine5aosj8v/PowerPivot%20Gallery/MDB%20Power%20View.xlsx'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.3128.0</HelpLink><ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName><ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">11.0.3128.0</ProductVersion><ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId><OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem><CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId><MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices"><Source>ReportingServicesLibrary</Source><Message msrs:ErrorCode="rsCannotRetrieveModel" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsCannotRetrieveModel&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.3128.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">An error occurred while loading the model for the item or data source 'http://win-hine5aosj8v/PowerPivot%20Gallery/MDB%20Power%20View.xlsx'. Verify that the connection information is correct and that you have permissions to access the data source.</Message><MoreInformation><Source>Microsoft.ReportingServices.ProcessingCore</Source><Message msrs:ErrorCode="rsErrorOpeningConnection" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsErrorOpeningConnection&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=11.0.3128.0" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">Cannot create a connection to data source 'TemporaryDataSource'.</Message><MoreInformation><Source></Source><Message>For more information about this error navigate to the report server on the local server machine, or enable remote errors</Message></MoreInformation></MoreInformation></MoreInformation><Warnings xmlns="http://www.microsoft.com/sql/reportingservices" /></detail>
    I decided I wanted to lower the file size, so I could just check the Excel file through Sharepoint, which I was previously unable to do since it was bigger than 200 MB. I removed some tables, making the file 199 MB.
    Back in Sharepoint, I could now view the Excel file, but my Power View error had also disappeared!
    Why can't Power View handle Excel files larger than 200 MB?
    Tuesday, June 3, 2014 11:21 AM


  • Hi Jasper,

    Are the upload and maximum file sizes already set to 2047MB in SharePoint? If not, doing this may resolve the issue since the default for SharePoint 2013 is 200MB which would explain why things stop working after this is exceeded. This help topic explains how you can change the limits: http://msdn.microsoft.com/en-us/library/ff487972.aspx.



    Please remember to mark a post that answers your question as an answer...If a post doesn't answer your question but you've found it helpful, please remember to vote it as helpful :)

    Website: nimblelearn.com, Blog: nimblelearn.com/blog, Twitter: @nimblelearn

    • Edited by Michael Amadi Tuesday, June 3, 2014 11:51 AM Minor correction
    • Proposed as answer by Darren GosbellMVP Wednesday, June 4, 2014 2:46 AM
    • Marked as answer by Charlie Liao Wednesday, June 18, 2014 1:13 AM
    Tuesday, June 3, 2014 11:46 AM