Export to excel or csv using R script with Specific format

[Lebunim]

Hi all,

I have created a report and I need to export certain part after analysis aplied. I created an R Script which run each time I refresh the data. I'm pretty happy with the end result, but I would like to improve format of the export. 

In my export I get Sequence (not needed), UserName (Needed), Date (bad format).

Script: 

# dataset <- data.frame(UserPrincipalName, Latest Usage, License Type, License Owner)

# dataset <- unique(dataset)

# Paste or type your script code here:

library(utils)

write.csv (dataset, file ="D:/Licenses/TelecomUserLicenseUsage.csv");

Can someone help me modify script to remove sequence column which is added automatically by R Script and change the date to this format - YYYY-MM-DD

Many thanks in adavance

[V-lianl-msft · Accepted solution]

Please try:

1. Convert all date columns to "Whole Number." 

2. Run the R scriptChange the datatype back to date once the script has provided an output.

[mahoneypat]

Have you considered using a Paginateed Report to export your data?  Or the new Power Automate visual, so you get just the fields you want, and then create file, email it or store on SharePoint, etc.

Pat