R Script & Power BI - Export Data to CSV file with specific formats

[ModrzeM]

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 advance

[andresrcs]

To get ride of the row names simply set row.names = FALSE in the write.csv() function, and to help you with the date format we would need some sample data or even better, a proper REPRoducible EXample (reprex) illustrating your issue.