Forum Discussion

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft 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

     

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
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