Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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().
If this solution works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Check out the July 2025 Power BI update to learn about new features.