Forum Discussion

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Solved

Reference 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...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    dkay84_PowerBI

     

    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

     

scottazrhc's avatar
scottazrhc
Icon for Advocate I rankAdvocate I
8 years ago

Did you ever find a workaround for this issue? For my purposes, it makes R in Power Query Editor frustratingly useless. It seems the most obvious need would be to selectively apply R functions against existing data, but for whatever reason, that is not supported. 

rlu's avatar
rlu
Frequent Visitor
7 years ago

Bump - has there been any updates in the last year that would allow us to reference an existing query and apply R functions against that data?