Forum Discussion
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 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.
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
4 Replies
Hi sundayDriver,
Please follow the steps in the snapshot below. It's Visual Studio Code in my test.
Best Regards,
Dale
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.
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
