Forum Discussion
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
- v-yinliw-msftCommunity Support
Hi cirodomingos ,
This link might help you:
Use R to export data from Power BI – The BIccountant
Hope this helps you.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- cirodomingosRegular 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