Forum Discussion

CanadianAnalyst's avatar
CanadianAnalyst
Frequent Visitor
6 years ago
Solved

Unable to load winCairo.dll

Hi, I'm trying to use custom R visualizations for Power BI desktop, but I'm getting an error code no matter what kind of visualizations I've tried to create.   My code works in Rstudio so this is p...
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI CanadianAnalyst ,

    It seems like you are working with libraries of external devices, I'd like to suggest you take a look at the limits of use R script in power bi R visual:

    Create Power BI visuals using R#known-limitations 

    Known limitations

    R visuals in Power BI Desktop have the following limitations:

    • Data sizes: Data used by an 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.

    • Calculation times: If an R visual calculation exceeds five minutes, it causes a time-out error.

    • Relationships: As with other Power BI Desktop visuals, if data fields from different tables with no defined relationship between them are selected, an error occurs.

    • Refreshes: R visuals are refreshed upon data updates, filtering, and highlighting. However, the image itself isn't interactive and can't be the source of cross-filtering.

    • Highlights: R visuals respond if you highlight other visuals, but you can't select elements in the R visual to cross filter other elements.

    • Display devices: Only plots that are plotted to the R default display device are displayed correctly on the canvas. Avoid explicitly using a different R display device.

    • RRO installations: In this release, the 32-bit version of Power BI Desktop doesn't automatically identify RRO installations; you must manually provide the path to the R installation directory in Options and settings > Options > R Scripting.

    Regards,

    Xiaoxin Sheng