Menu
What's the best way to have R functionality in MS SharePoint? Would RExcel work if I import an Excel sheet in SharePoint using Excel Services? Any other options?
581
The Microsoft365R package makes it easy to connect R with Outlook, Teams, OneDrive, and SharePoint.
Microsoft R Open is the enhanced distribution of R from Microsoft Corporation. It is a complete open source platform for statistical analysis and data science.
Microsoft365R extends the interface to the Microsoft Graph API provided by the AzureGraph package to provide a lightweight yet powerful interface to SharePoint and OneDrive, with support for Teams and Outlook soon to come.
Here is another way to get the direct URL of any file in SharePoint Online. Just select the file >> Open the document information panel by clicking on the “i” icon and clicking on the little copy icon under “Path”! This gets you the direct URL of the document in your clipboard!
If you have SharePoint you must have a SQL Server license, thus why not make a table or database called R_DataAnalysis and then use PowerPivot or PowerView with SSRS to display your data?
106
R exports to flat file very easily with:
write.csv(dataframe,'someFile.csv')
These can easily be imported for use in SharePoint BI functionality.
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
