Query Editor R how to see the dataset

[sundayDriver]

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 goal was to be able to debug what is happening, so I wanted to execute the script in Visual Studio first but then can I didn't know the path to the power BI dataset (I'm using power BI desktop). I've already looked at this article, but it was quite generic and didn't seem to help.

[v-jiascu-msft]

Hi @sundayDriver,

Could you please mark the answer as a solution?

Best Regards,

Dale

[v-jiascu-msft]

Hi @sundayDriver,

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

Best Regards,

Dale

[sundayDriver]

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 · Accepted solution]

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

Best Regards,

Dale