Data refresh : memory error

[Medmbchr]

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 · Accepted solution]

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.