Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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."
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?
I have same issue with R-3.6.0, R-3.6.2 or with R-3.5.0. Anyone who could fix the issue?
I did get this working in the end with R-3.5.2
I'm also running into this problem. Installed earlier version of R (3.5.0), but this did not help.
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.
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.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Thanks, but this didn't resolve the error for me unfortunately.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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
Hi,
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"])
Same here.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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...
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |