Reduce the size of an Excel workbook to view it in Power BI
You can upload any Excel workbook smaller than 1 GB to Power BI. An Excel workbook can have two parts: a data model, and the rest of the report—the core worksheet contents. If the report meets the following size limits, you can save it to OneDrive for work or school, connect to it from Power BI, and view it in Excel Online:
- The workbook can be up to 1 GB.
- The core worksheet contents can be up to 30 MB.
This article tells you what you can do to limit or reduce the size of an Excel workbook so that it meets the size requirements for uploading data.
What makes core worksheet contents larger than 30 MB
Here are some elements that can make the core worksheet contents larger than 30 MB:
- Images
- Shaded cells
- Colored worksheets
- Text boxes
- Clip art
Consider removing these elements, if possible.
If the report has a data model, you can reduce the overall size of the report using information in Create a memory-efficient Data Model.
You can also refer to this article on File size limits for Excel workbooks in SharePoint.
Workbook size optimizer
If your workbook contains a data model, you can run the workbook size optimizer to reduce the size of your workbook. For more information, see Download Workbook Size Optimizer.