Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am checking this documentation:
Create advanced analytics and visualizations using R scripts - Power BI | Microsoft Docs
Where they confirm: "The version of R deployed in the Power BI service is Microsoft R 3.4.4."
But here it says its not the latest: Installing Microsoft R Open 3.4.4 [Archived Documentation] . MRAN
and it takes me to Installing Microsoft R Open . MRAN (4.0.2)
I want to develop and later be able to deploy it in Power BI Service, so I want to use the same version, shall I use 3.4.4 or 4.0.2?
(My guess is in the very near future Power BI will have 4.0.2 ....)
Hi @v-yiruan-msft
I already voted up the idea Microsoft Idea · Export the data into Excel by using R language code, this is working in desktop le.... The problem is, that this idea has a red "NEED VOTES" label on it... Was created over a year ago, and nothing happened yet. Installing a small package should not be such a complicated task.
When can we expect something to happen in this area?
I looked at the already installed R packages on the Power BI Service platform, and only found a package "gdata" which is able to export csv/text files. I would like to export excel files. For this I would need the previously mentioned "openxlsx" or the "XLSX" package from R.
Is there another workaround or package which one can use to export to excel using R in power BI service?
Thank you
Hi @ovonel ,
The version of R package is 3.4.4, you can find the details in this official documentation. If you would like to request support of an R package not found in the list of following link, please submit your request to Power BI Ideas.
R packages that are supported in Power BI
Best Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |