Forum Discussion

sundayDriver's avatar
sundayDriver
Microsoft Employee
8 years ago
Solved

Query Editor R how to see the dataset

Hello, I'm new to R scripting and I'm trying to manipulate some column data. I selected the R script option but I can find a way to see the format of the 'dataset' in order to write the code. My goa...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi sundayDriver,

     

    My bad, the step 2 is launched from the R visual rather than the Query Editor. I'm afraid we can't use the R IDE from Query Editor. But my steps could be a workaround. Import data in Query Editor -> Add the desired column in the R visual -> Launch the R IDE -> Can work with the dataset now. 

    Reference: https://docs.microsoft.com/en-us/power-bi/desktop-r-ide

    Query_Editor_R_how_to_see_the_dataset2

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi sundayDriver,

 

Please follow the steps in the snapshot below. It's Visual Studio Code in my test.

Query_Editor_R_how_to_see_the_dataset

 

 

Best Regards,

Dale

sundayDriver's avatar
sundayDriver
Microsoft Employee
8 years ago

Hi v-jiascu-msft

Thank you for the response and help!

I had one more question: How can I find the arrow in step marked with '2'? Finding the local path of the dataset is my main blocker.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi sundayDriver,

     

    My bad, the step 2 is launched from the R visual rather than the Query Editor. I'm afraid we can't use the R IDE from Query Editor. But my steps could be a workaround. Import data in Query Editor -> Add the desired column in the R visual -> Launch the R IDE -> Can work with the dataset now. 

    Reference: https://docs.microsoft.com/en-us/power-bi/desktop-r-ide

    Query_Editor_R_how_to_see_the_dataset2

     

    Best Regards,

    Dale