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.
I have been using R scripts in my PowerBI Desktop Power Queries for over a year, but after updating to the latest version of R, 3.6.0 (Current CRAN version) the queries fail with the following error: Details: "Exception of type 'Microsoft.Analytics.Modules.R.ErrorHandling.RException.Primitives.NotValidRDataException' was thrown."
This occurs for my existing R scripts as well as really simple new ones. (such as the following: = R.Execute("output <- data.frame(test = 7)"))
Based on searching, I believe other people are also experiencing the same issue. Here is a thread discussing it, but I could not find an issue referring to it.
https://community.powerbi.com/t5/Desktop/Connecting-to-R-dataset-unable-to-connect/td-p/680953
The error seems to not occur if I use the options menu to switch the version of R used by Power BI back to 3.5.1 although others said otherwise.
Here is the change in R 3.6.0 I think is most likely to cause the this issue:
R change:
Serialization format version 3 becomes the default for serialization and saving of the workspace (save(), serialize(), saveRDS(), compiler::cmpfile()). Serialized data in format 3 cannot be read by versions of R prior to version 3.5.0. Serialization format version 2 is still supported and can be selected by version = 2 in the save/serialization functions. The default can be changed back for the whole R session by setting environment variables R_DEFAULT_SAVE_VERSION and R_DEFAULT_SERIALIZE_VERSION to 2. For maximal back-compatibility, files vignette.rds and partial.rdb generated by R CMD build are in serialization format version 2, and resave by default produces files in serialization format version 2 (unless the original is already in format version 3).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.