Error on Loading Data using R

[Navald]

The R for loading data is using excessive RAM.

I use R to load data onto PowerBI because I have to do some operations before hand. My system has 48 Gb RAM and its running out of RAM when data is loading. 

The RAM is being used by the multiple R sessions that start on data refresh.

The same script when I run outside of PowerBI on Rstudio , it hardly uses 10% of RAM. 

Please help in understanding how to solve the issue of POwerBI running weirdly multiple sessions of R and then using a lot of RAM by each of them.

[mahoneypat]

Just brainstorming here, but are you doing merges with the loaded R data table(s)?  You may be unintentionally reloading for each row of data.  See this video by Chris Webb with GuinInACube.  May be an application for Table.Buffer().

https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=2ahUKEwi_tpTl67Xp...

If this solution works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat