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

6 Replies

  • 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

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi Anonymous,

    Power BI desktop uses much RAM when you import large dataset to it. In your case, please increase your RAM to 8GB/16GB, or import data in parts from Excel .


    Thanks,
    Lydia Zhang

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      K got it.

      can u please tell me, is there any restriction defined by default for number of records to be retrieved in Power BI Desktop when we load an excel file or is that only in terms of Memory (MB or GB) irrespective of the records.

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Hi Anonymous,

        According to my knowledge, there is no restriction about the number of records when you load an Excel file. However, large number of records may cause memory issue, which will prevent Power BI desktop from loading data.


        Thanks,
        Lydia Zhang