Global Power BI User Group

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Getting memory error..suggest me

  • 1.  Getting memory error..suggest me

    Bronze Contributor
    Posted Nov 09, 2017 04:52 AM
    Hi All,

    I am getting below error in loading data into Power BI Desktop from SQL Server on prime, number of records are 9485777

    There's not enough memory to complete this operation, please try again later when there may be more memory available.

    I noticed that one more exe (msmdsrv.exe) is automatically running with Power BI which consuming lot of memory.

    so please help me

    Thanks
    kamal maru
    9810376859

    ------------------------------
    KAMAL MARU
    Team Lead - Power BI/MSBI/SQL
    HCL America
    New Delhi
    9810376859
    ------------------------------


  • 2.  RE: Getting memory error..suggest me

    Bronze Contributor
    Posted Nov 10, 2017 12:33 AM
    Hi there,

    Are you using the X86 or X64 for Power BI Desktop?

    It would appear that you are using the X86 (32bit) which has a memory limitation which you are now hitting. 

    I would suggest installing the X64 (64bit) which will allow it to access all the memory available on your PC.

    If that still fails then ensure that your cardionality of your columns is as low as possible, which will ensure that you get the best compression.

    Regards
    Gilbert