Forum Discussion
R- Auto-Schedule Data Export From Power BI to Sharepoint Folder
Hi,
I'm trying to automatically export the dataset from Query editor to the SharePoint folder (in CSV format).
I saw that there is a possibility with the R script.
I'm trying this script but it doesn't work.
# 'dataset' holds the input data for this script
system("curl --NTLM --USERNAME username: PASSWORD --upload-file dataset
https://COMPANYNAME.sharepoint.com/:f:/r/sites/SGDM-frreports/Shared%20Documents/Proba.csv")
Hi Anonymous ,
Seems that you should use
system("curl --ntlm --user username:password --upload-file someFolderin your script,check the thread below:
Saving files to SharePoint folder from R - Stack Overflow
Or you could try to use Powershell to realize it:
How to migrate data from a CSV file to SharePoint using PowerShell (practical365.com)
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
3 Replies
- mahoneypat
Microsoft Employee
It is easier to scheduled exports using a paginated report (now possible without premium capacity). You can use the approach shown in this video, or just publish the simple paginated report, subscribe to it at desired frequency, and use a Flow to pick up the file from your email and move it to SharePoint.
Export data with Power BI Paginated URL Parameters | Guy in a Cube
Pat
v-kelly-msftCommunity Support
Hi Anonymous ,
Seems that you should use
system("curl --ntlm --user username:password --upload-file someFolderin your script,check the thread below:
Saving files to SharePoint folder from R - Stack Overflow
Or you could try to use Powershell to realize it:
How to migrate data from a CSV file to SharePoint using PowerShell (practical365.com)
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
