Hi! I am getting an error when I try to follow the steps in the doc here https://docs.microsoft.com/en-us/power-bi/desktop-r-scripts
Essentially I would just like to try to run an R script to connect to data. I have installed R in my local machine and I am not entirely sure what I am missing here. Help you be much appreciated!
The error I am getting is:
Details: "Exception of type 'Microsoft.Analytics.Modules.R.ErrorHandling.RException.Primitives.NotValidRDataException' was thrown."
I am getting the same error whie trying to follow the below example, i can run the commands in RStudio but can not pull into power bihttps://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-r-scripts-in-power-bi...
I have the same error here when using below script
= R.Execute("# 'dataset' holds the input data for this script#(lf)write.csv(dataset,""C:/Users/Documents/test2.csv"")",[dataset=#"Renamed Columns"])
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut!
How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
It seems to be R-3.6.0 cause this error.
I install R-3.5.3 side by side and configure it to R home directory in PBI Desktop.
Then error message dissapears.
Thanks, but this didn't resolve the error for me unfortunately.
id installing a lower version also and this didnt resolve it for me either, although i did leave the higher version installed, did that need uninstalling or shoudl i just have had to change the version in power bi (which i did)
Same error here
Don't think that this will resolve it.
On 3.6.0 I get the exeption-error from above and if I go down to R Open I receive an empty table (while RStudio shows 2 tables of data).
So this is still buggy, unfortunately.
I'm also running into this problem. Installed earlier version of R (3.5.0), but this did not help.
Engage and empower students with Power BI!
Continue your learning in our online communities.
Travel to Melbourne and network with thousands of peers!