PowerPivot & PowerView can hold more data with Workbook Size Optimizer
Workbook Size Optimizer
The Workbook Size optimizer for Excel can better compress data inside workbooks
that use PowerPivot or PowerView if this data comes from external data sources.
The best size compression can be achieved for workbooks based on SQL Server
databases and there are a few tricks we can do for other SQL datasources as
well. The optimizer will install as an add in to excel and will provide you
with a nice wizard to better compress the size of your workbook. Using the
optimizer you can often get more than 1,000,000 rows datasets in a workbook
under 10 MB, share it in SharePointOnline and interact with it using the Excel
Web App in any browser.