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
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??

      • ludovit8's avatar
        ludovit8
        Icon for Helper I rankHelper I
        8 years ago

        When I had there only 15 sql databases  (company bookeepings) it need just about 16GB ram during total refresh.

        Now I have there about 39 companies and it need 41GB of RAM.  I had to ask my bosses for stop buying new companies :-(

Related content