Forum Discussion
Connecting to R dataset - unable to connect
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."
13 Replies
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)
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 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 bi
https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-r-scripts-in-power-bi-desktop-part-3/Same here.
Hi All!
Has anyone eventually resolved this issue?
I'm trying to connect to MS Azure Machine Learning Studio via PowerBI get data through R script and getting the same error:
"Details: "Exception of type 'Microsoft.Analytics.Modules.R.ErrorHandling.RException.Primitives.NotValidRDataException' was thrown.""
Running:
Windows v10
R v3.5.0
Power BI v2.69.5467.2151 64-bit (May 2019)
RStudio 1.2.1335
AzureML library
I'm getting the same error. Has anyone resolved without downgrading R?
I first got error messages due to bugs that were internal to my R code. Then after I fixed those bugs, I started getting this error. I conclude that my R code likely works and that the error is in the connection between R and Power BI. Perhaps Power BI doesn't like the way the R script is outputting results?
