Forum Discussion
Reference existing query from R script
We can only reference the existing query with Power Query by starting from a Blank Query and type = Query1, which will reference to an existing query called "Query1".
We can use R Script to get data, perform data cleansing, advanced data shaping and analytics in datasets, including completion of missing data, predictions, and clustering. For details please refer to https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-in-query-editor/.
But we cannot reference existing query from R script as you desired.
Best Regards,
Herbert
If you mean pass a query table to the R script engine and have it return the results of an R analysis as a visual, see https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-r-visuals/
No I am looking to perform some calculations and transformations using R, not visuals, for this use case. Thanks though