Forum Discussion

Kumar11109's avatar
Kumar11109
Icon for Helper IV rankHelper IV
8 years ago

There's Not Enough Memory To Complete This Operation

Hi All,    I am loading the data from SQL server. I am trying to refresh the data for my tables. But the data is not able to refresh and the below is message is reported:    The operation could n...
Need Help
Kumar11109's avatar
Kumar11109
Icon for Helper IV rankHelper IV
8 years ago

MattAllington

Hi Matt, 

I am really sorry, I meant that 15 columns only. And I have 8 tables with relationship across them and no table has more than 15 columns individually, but if combined, then yes. 

 

Thank You, 

 

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Kumar11109,

The error message means you don't have enough memory. Please extend your memory as much as possible. You can refer to this article(though the article is about PowerPivot, it should be similar with Power BI) to optimize your data model in a way that makes a better use the available memory. For another thing, if you upload the data in import model, please disable "Allow data preview to download in the background" from options / options and settings/data load. And check if it is useful.

Best Regards,
Angelia

  • Kumar11109's avatar
    Kumar11109
    Icon for Helper IV rankHelper IV
    8 years ago

    v-huizhn-msft

     

     I tried using the above details, but still to no avail.... :-C. 

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi Kumar11109,

      When you create a simple table in Power BI desktop, there is no problem for Power BI function. You have to extend your memory.

      Best Regards,
      Angelia

      • Kumar11109's avatar
        Kumar11109
        Icon for Helper IV rankHelper IV
        8 years ago

        Ram ??? if I have to increase it, then would 16gb be enough??

Related content