Export Excel with R Script in Power BI

[Syndicate_Admin]

Hello, friends I have this script in R

library("writexl")

write_xlsx(dataset, "C:/Users/David.Ortega/Documents/DatosDev/reporte_leterago.xlsx")

Works OK

but it only gives me a record in the sheet in excel and I want ALL the contents of the table, when I open the script window it mentions that the duplicate rows will be removed, but they are all removed. as I do to export ALL the data of the query.

imagenimage

Thank you

[v-stephen-msft]

Hi @israeldavid76 ,

 So the full R-code looks like this:

require(gdata)
write.table(trim(dataset), file=”your filepath & filename.txt”, sep = “\t”, row.names = FALSE)
plot(dataset);

Please refer to

Use R to export data from Power BI – The BIccountant

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin · Accepted solution]

I need .xls, no txt, because with the opction export data, export a csv file, but my client need a XLSX. y just find the solution, Thanks.