Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Unable to Load Large Excel Files

Able to load 4MB Excel file but unable to load 86 MB of excel. Is there any reason behind...!! Um with Power BI free version and May 2016 Updated.
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi Anonymous,

We need to know that how you connect to Excel file from Power BI Desktop, using File ->import->Excel Workbook Contents option or Get data-> Excel option? And please help to post the full error message that you get.

If you use File ->import->Excel Workbook Contents option to import data from Excel file to Power BI Desktop, as stated in this article, there is currently no limitation on the size or number of objects in the Excel workbook, but larger workbooks take longer for Power BI Desktop to analyze and import. However, please note that when you have linked tables in Excel, there is a size limitation of 1 million characters.

Thanks,
Lydia Zhang

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi Lydia,

     

    Thanks for th reply. I try to import excel file as

    Get data > Excel > Load / (Edit > Close and Apply)

    and um getting following error message after long time :                                                                                                                     

    My PC: 4GB RAM in which i can see 1.5GB is free while i start Power BI Desktop Application on my lappy.

    um i missing anythin here...??

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      I'm facing the same issue and this is not comprehensible. In my case i didn't even see the "Get data" button. It disappeared. And a 50 MB file can not be uploded in PowerBi Service by the "Upload" button. Is there any solution for this??? Please help. 

      See the error message below