R Scrips in Services: Openxlsx unavailable for Power BI Could Services

[rohitbinnani]

Hi Team,

I am a pro user and we built a report for our client which generates Excel export with just change of data in Dashboard. Unfortunately, after the complete development, we encountered that openxlsx package is not available in Power BI services is throwing the below error. Please help me by installing this package for R in Power BI Cloud services.

-------Error Message---------

Missing R Package
Package 'openxlsx' is currently unavailable
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 5a4e7508-2e2c-4502-9ae1-4762ad128245
Request ID: 6ac16337-2ae5-71b9-fa11-05bcd916e21d
Correlation ID: 1519c934-909e-b9f4-6272-521cb45498fc
Time: Thu Mar 28 2019 13:15:08 GMT+0530 (India Standard Time)
Version: 13.0.8885.144
Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net

[v-shex-msft · Accepted solution]

Hi @rohitbinnani ,

You can't add custom R package to power bi service side.

Below is the R packages power bi service support, you can check them to know more about this:

R packages in the Power BI service

In addition, please also take a look at following document to know the limitations when you run r script on power bi service side:

Creating R visuals in the Power BI service

Regards,

Xiaoxin Sheng