Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
mkeisha
Helper I
Helper I

Error: Couldn't Open the Workbook

We created a 72 MB PowerPivot model with lots of Slicers, Pivot Tables and charts in Excel 2013 that we would like to share within the PowerBI service. So we saved the workbook in One Drive for Business and uploaded to the PowerBI service via Get Data, Files, One Drive for Business, Connect, Connect, Manage & View Excel in Power BI.  The workbook seemed to load successfully as a report.  But as soon as we clicked on the report, we received an error message as follows:

 

"Couldn't Open the Workbook.  Sorry, we can't open your workbook in Excel Online because it exceeds the file size limit.  You'll need to open this in Excel."

 

What's going on here.  Are we out of luck?

 

Thank you.

3 REPLIES 3
austinsense
Impactful Individual
Impactful Individual

The limit for viewing an Excel report like that online is 10MB - that's the option you choose.

 

The other option "Import Excel Data into Power BI' has a 250MB limit (soon to be raised).  This second option brings in the whole data model and allows you to build PBI reports.

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

Thank you for your response.  But what doesn't make sense is that we have other similiar files that are approximatly 65-68 MB that work fine.  (Again, created in PowerPivot originally and loaded into PowerBI service the exact same way.)  I'm wondering if our issue is related to the file size limitation for the "Excel" component (slicers, pivot tables, graphs) as opposed to the "model" piece. (tables, DAX measures, etc.)

 

What do you think?

austinsense
Impactful Individual
Impactful Individual

I see you're trying to be anonymous 🙂 You might be right about the file size thing - I'd have to see you do it both ways to understand what was happening.

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.