Forum Discussion

cdok1091's avatar
cdok1091
Icon for Advocate II rankAdvocate II
9 years ago

importing multiple dataframes from an R environment file (.RData)

I have an R environment file (.RData) with ~120 dataframes whose combined file size when exported to text files is ~90MB.  When I load the R environment into Power BI Desktop via R script... load(fil...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi cdok1091,

You have got a great discovery in this thread. 

When we download Power BI desktop, there are no limitation for loaded file. The efficency depands on our computer memory and performance. Usually, in order to reduce the amount of RAM your Data Model uses, we must consider casting the columns to the appropriate data types.

Here is an article to optimize data model to improve the performance.

Data Import Best Practices in Power BI and Power BI Performance Tips and Techniques.

Best Regards,
Angelia