The R.Execute () Power Query function only allows you to use R for ingesting data. Ideally, make R.Execute () more powerful by making it a data transformation function as well as data source. Let data be loaded from other sources, and then R.Execute () could be called in a subsequent step in the Power Query query. let Source = Excel.Workbook(File.Contents("C:\[...].xlsx"), null, true), Custom1 = R.Execute("df<-data.frame(Source) [...]") in Custom1 Transformations could all be done in R first, but it's slower in general, and you lose the convenience of blending data in Power BI itself.
... View more