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

I have the same issue but with less than 10 dataframes. Loading them works fine using R studio but loading them in powerBI only returns the first (in alphabetical order) dataframe to select.

The problem is Power BI doesn't look like it's designed for people who just want to use it to visualise data that's pre-prepared on R. You're almost forced to do all the data preparation in Power BI and just use R for adhoc queries and visualisations.