Forum Discussion

fredrikg's avatar
fredrikg
Helper I
10 years ago

Excel file size - max 10 MB or not?

Hi!

 

I have an Excel file, the size is 26 MB. The actual workbook is empty, so the data model stands for the entire size, more or less.

I double-checked this by renaming the file to file.zip and located model\item.data - it is 26 MB.

 

The file is located in OneDrive. When I try to "Get Data->Files->OneDrive for business->Connect, Manage and View in Excel", I receive this message:

"Support for workbooks > 10 MB is currently not available"

 

But this contradicts https://support.powerbi.com/knowledgebase/articles/723615, which states that this would work if:

The workbook as a whole can be up to 250 MB.

The core worksheet contents can be up to 10 MB.

 

What gives? I have Power BI Pro, if that matters.

 

/Fredrik

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    10 years ago

    Definitely seems odd, I have Excel spreadsheets up in the service that are greater than 10MB total because of the data model. Probably want to send a frowny face to support, upper-right corner in the service.

  • ashishrj's avatar
    ashishrj
    Power Participant
    10 years ago

    fredrikg If you have a Power BI Pro account then data model upto 250 MB should work! You should definitely send a frown.