Forum Discussion

Medmbchr's avatar
Medmbchr
Icon for Helper IV rankHelper IV
3 years ago
Solved

Data refresh : memory error

Hi

 

I am currently working on several Power BI dashboards with direct connection to an SQL Server database. I am developing all these using my personal laptop but I use my client's laptop to refresh the data since I cannot have VPN (my client's internal policy).

 

When I try to refresh data from my client's laptop (i5, 8 gb of RAM), I get a memory error for all the tables, hence I refresh tables one by one (which I cannot do forever, it's over 50 tables).

 

How can I bypass this error on this specific client's PC?

 

Thanks

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Medmbchr ,

     

    According to your statement, I think your error should be caused by the memory limitation of your laptop. This is usually caused by insufficient memory on the hardware's behalf to process the given tasks. You can increase the available memory, or you can also works on virtual machines (seems this is not support by internal policy). 

     

    Or you can 

    >Make sure Automatically manage paging file size for all drives option is checked.

    >Click OK to save the changes.

    >Restart the computer and check if the memory allocation failure error.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Medmbchr ,

     

    According to your statement, I think your error should be caused by the memory limitation of your laptop. This is usually caused by insufficient memory on the hardware's behalf to process the given tasks. You can increase the available memory, or you can also works on virtual machines (seems this is not support by internal policy). 

     

    Or you can 

    >Make sure Automatically manage paging file size for all drives option is checked.

    >Click OK to save the changes.

    >Restart the computer and check if the memory allocation failure error.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.