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 d...
I think this feature has already been implemented. Here is an example let Source = #table({"num"},List.Accumulate({1..10},{},(s,c)=>s&{{c}})), RScript = R.Execute("df<-dataset#(lf)df$fact<-factorial(df$num)",[dataset=Source]), out = RScript{[Name="df"]}[Value] in out
