Forum Discussion

cirodomingos's avatar
cirodomingos
Regular Visitor
3 years ago

Export Result of an R Visual

Hi!

Thanks in advance for you time. I always use this community and it's very helpful, although is my first support request.

 

Without further ado, I have this R Visual that does some calculations to display a graph. The issue I'm facing is that I need to extract the data from the R Visual, but I need the data after the calculations that are done inside of it and not the data that is used as an input to the R Visual.

I've already tried:
1. Export a csv table from the "..." icon on top right of the visual

This doesn't work since it extracts the input table to the visual, and not the output

2. Using "write.csv" or "write_xlsx" functions inside the R visual.
They work, but only on Power BI Desktop, on Power BI Service I get the message "Package writexl is currently unavailable"

3. Using R script to create new columns in Power Query

This also doesn't work, since I need the User selection on the slicers to filter the data before doing the calculations in R. The calculations won't work properly if we don't take into account the User selection

 

Any idea is much appreciated.

Thanks!
Ciro

2 Replies

    • cirodomingos's avatar
      cirodomingos
      Regular Visitor

      Hi v-yinliw-msft,

      Thanks for the fast answer.

      I've tested it and unfortunately it ended up in the same dead-end as option 2 with the "write_xlsx" or "write.csv" functions:
      "Package 'sos' is currently unavailable"


      ID da atividade: 99ece0bb-a18f-48b9-a045-ccbc8ce978a1
      Solicitar ID: 5340c991-102f-4b59-bbac-444c785276be
      ID de correlação: dd51602e-8760-02e7-83bf-687ebfed818a
      Hora: Fri Oct 14 2022 11:42:35 GMT-0300 (GMT-03:00)
      Versão do serviço: 13.0.19226.41
      Versão do Cliente: 2210.1.13426-train
      Cluster URI: https://wabi-north-europe-d-primary-redirect.analysis.windows.net/


      Thanks and regards,
      Ciro