Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Power BI memory limit

I am using a laptop with 8 GB of ram. I am getting an memory error after loading 1,47GB of data from multiple excel tables into a appended table. What can I do to solve this?

 

Can I use the service (I have a pro account) to refresh this report? How can I change the source of a excel file from my local folder to my onedrive folder? I don't want to rebuild the report all over again.

 

Is it possible to change the origin of the tables in the power bi service?

Need Help
Show and Tell
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Anonymous,

     

    Currently, there is no restriction on how large a pbix file can be locally. However, when you publish a pbix file over 1GB to Power BI Service, you will get a file size limit message. And in the case that your pbix file is less than 1GB when importing it to Power BI service, but the data model grows beyond 1 GB after a period of time, you will get a message when refreshing the dataset. 

     

    So you connect to your onedrive excel on Power BI services.

    How can I change the source of a excel file from my local folder to my onedrive folder? I don't want to rebuild the report all over again.
    Currently, we cannot change the datasource from local excel to the excel files that stored in onedrive. I am afraid you need to recreate the reports.

     

    If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
    https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Thank you for your understanding.

     

    Regards,

    Charlie Liao

12 Replies

  • cs_skit's avatar
    cs_skit
    Resolver IV
    9 years ago

    Can you post more details about the error? Imho the chance is high that its not your 8GB physical ram thats the issue theres pagefile and such.

     

    Also maybe try with the 64 bit version of PowerBI if you got 32 one installed.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I have Power BI 64 bit and the error is

       

      Error Message:

      Failed to save modifications to the server. Error returned: 'The operation has been cancelled because there is not enough memory available for the application.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        To explain my problem with more detail, I have monthly equal tables from the orders I'm analysing since July 2016

         

        Then I have a "master table" that appends all the data together and I use that table to create visuals on the report.

         

        Could this be a problem?

         

  • v-caliao-msft's avatar
    v-caliao-msft
    Microsoft Employee
    9 years ago

    Anonymous,

     

    Currently, there is no restriction on how large a pbix file can be locally. However, when you publish a pbix file over 1GB to Power BI Service, you will get a file size limit message. And in the case that your pbix file is less than 1GB when importing it to Power BI service, but the data model grows beyond 1 GB after a period of time, you will get a message when refreshing the dataset. 

     

    So you connect to your onedrive excel on Power BI services.

    How can I change the source of a excel file from my local folder to my onedrive folder? I don't want to rebuild the report all over again.
    Currently, we cannot change the datasource from local excel to the excel files that stored in onedrive. I am afraid you need to recreate the reports.

     

    If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
    https://ideas.powerbi.com/forums/265200-power-bi-ideas

     

    Thank you for your understanding.

     

    Regards,

    Charlie Liao

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      I solved this problem by rebuilding my report doing all the calculated fields in Power BI instead of Excel. 

    • chfio's avatar
      chfio
      Regular Visitor
      8 years ago

      Is this still not possible. I think i've edited souce via advenced query editor to shift from local to onedrive