none
This workbook could not be enabled in Power BI for Office 365 because the worksheet contents (the contents of the workbook that are not contained in the data model) exceed the allowed size.

    Question

  • I got the Power BI preview trial link and signed up. I uploaded a 56MB workbook with a Power Pivot data model and got the following error. Any suggestions on what the exact size limitation is for content not in the data model?

    Sorry, something went wrong
    This workbook could not be enabled in Power BI for Office 365 because the worksheet contents (the contents of the workbook that are not contained in the data model) exceed the allowed size.
    Technical Details
    Correlation ID:
    911E9EED-0DC2-9C5E-98A5-2BD47D2BE547
    Date and Time:
    08/28/2013 5:30:33 AM

    http://artisconsulting.com/Blogs/GregGalloway

    Wednesday, August 28, 2013 10:35 AM

Answers

  • The answer is correct. You have more than 10MB in the part of the Excel file that is not the data model.

    The main reason that can cause this problem is that you imported external data into the model but it is also in Excel tables.

    This could happen when you use Power Query or when you import the data from Excel itself.

    When you use Power Pivot for importing data, Power Pivot will not store the data in the Excel grid but only in the model.

    You should avoid placing large tables in Excel because the compression applied to normal Excel data is much less efficient than the compression in the Power Pivot model.

    Wednesday, August 28, 2013 1:34 PM

All replies