Forum Discussion
dkay84_PowerBI
Microsoft Employee
Microsoft EmployeeReference existing query from R script
I know that you can import data (i.e. from URL or local file) using the custom R Script in Query Editor, but is it possible to load the data using a regular UI-based query and then reference that que...
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
BhaveshPatel
Super User
Super User
As far as I am aware, this is not possible in integrated R environment at this stage.