2

I inherited an Excel data model consisting of multiple workbooks. Each workbook has multiple tabs utilizing Power Queries to get, transform and load data sets from base supporting Excel and csv files.

Over time the files of the model have grown tremendously (upwards of 30MB) in size causing Excel to hang or crash. It has only been recently that I discovered Excel Power Query has a file size limitation of 10MB.

I am now considering a redesign of the model using Microsoft Power BI and want to know if there are any such limitations that will need to be considered.

2

Refer to this support article it seems that the file size is limited to 1GB: Power BI Increases File Size Limit from 250 MB to 1 GB

| improve this answer | |
  • 1
    That limit is only relevant to files uploaded to the web service, using a Free or Pro license. The current limit for a Premium license is 10GB. Using Power BI Desktop, you are only limited by the RAM available on your machine. – Mike Honey Aug 24 '19 at 8:22
  • the link is broken – Przemyslaw Remin Feb 24 at 17:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.