Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Hi @sundayDriver,
Could you please mark the answer as a solution?
Best Regards,
Dale
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |