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 servic...
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

cs_skit's avatar
cs_skit
Resolver IV
9 years ago

 

What you could do is either reduce your number of columns and such you are importing so make the importing data less taxing.

 

OR

 

For authoring the Report work with data files containing only a subset of the rows just to have the structure. Then after you publish the report to the service refresh the Files using a Gateway from the big files into the service.

 

 

But my guess is that simplifying your source data might be good anyway. Only read the columns you really need.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

The thing is I already deleted the columns that have no interest for me. Does the Power BI service have more capacity to process this data? 

  • Thiyagu's avatar
    Thiyagu
    Helper III
    9 years ago

    Maybe you have lot of unique records.

     

    Try to load with less number of columns and check what PBI service capable of..

     

    In your data, how many columns and rows it has?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      22 columns and ~12 M rows

       

      I'm going to try to do it in the service, atm I was doing it in the PB desktop

      • Thiyagu's avatar
        Thiyagu
        Helper III
        9 years ago

        Try to cut down the columns and check.. 

         

        You are getting this error in PBI service only right?