Error when refreshing report with R script 'there is no package called...'

[Anonymous]

I've built a report using some R script to transform some data imported from SQL server. It refreshes fine on the desktop mode, however once published it throws the following error when trying to refresh:

"Underlying error messageADO.NET: R script error. Error in library(tidyverse) : there is no package called 'tidyverse' Execution halted"

The R script references the tidyverse package with "library(tidyverse)" but it appears the service can't find it.

Any idea how to fix this?

[Icey]

Hi @Anonymous ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[Icey]

Hi @Anonymous ,

1. Please keep your ‘tidyverse’ package consistent with that provided in the official documentation.

    The ‘tidyverse’ package version is 1.2.1 and here's the link.

2. Here are some documents which may help you:

Power BI: R Home Directory vs Library Trees

Error when running make: "there is no package called ..." + solution

Best Regards,

Icey

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