R Visual workspace error

[Anonymous]

Team,

when we publish report with Rvisual to power bi service. We get script runtime error without much information on debugging. Since we published report with R version 3.6.1 and it is not supported in power bi service r visuals might not work as per r visual limitations.

We tried following steps to resolve it:
a. Use R 3.4.4 version in power bi desktop as this version is supported in power bi service.
b. Uninstall all latest R version and install packages version supported by power bi service.
c. Still we are getting following error in power bi desktop:

Error in readRDS(pfile) :
cannot read workspace version 3 written by R 3.6.1; need R 3.5.0 or newer
Calls: library -> find.package -> lapply -> FUN -> readRDS
Execution halted

We also added R_DEFAULT_SAVE_VERSION and R_DEFAULT_SERIALIZE_VERSION to 2 for resolving workspace issue but it is not resolved.
Please suggest solution to resolve this.

Thanks

Vivek

[Icey]

Hi @Anonymous ,

I have tested on my side, and it works well.

Please check: R visuals in the Power BI service have a few limitations.

Some of these limitations may be related to your sceanrio:

1. Data size limitations – data used by the R visual for plotting is limited to 150,000 rows. If more than 150,000 rows are selected, only the top 150,000 rows are used and a message is displayed on the image.

2. Calculation time limitation – if an R visual calculation exceeds 60 seconds the script times out, resulting in an error.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Icey 

  Did you try with 3.6.1 and libraries(jsonlite) and library(httr) and call API in power bi workspace ? We tred with this and this throws error.We have dataset column values to 5 and script execution does not takes more time.

THanks

Vivek

[Icey]

Hi @Anonymous ,

I don't know much about the usage of these two packages. So, please give me an example PBIX file without sensitive information. And I'll test on my side.

Best Regards,

Icey