Forum Discussion

mstarks's avatar
mstarks
Icon for Advocate I rankAdvocate I
9 years ago
Solved

auto export of data

Hello - I understand that we will soon be able to get a snapshot of reports auto-emailed on a daily or weekly basis.  Do you know if it is or will be possbile to auto-export data from a Power BI tabl...
alanhodgson's avatar
alanhodgson
Icon for Solution Supplier rankSolution Supplier
9 years ago

Hey mstarks,

 

I did a workaround for this in R a while back (before the export to excel option). You can find the post here.

 

It isn't automatic, but by running the visual or updating the dataset, it will export the data (in a table format) to a CSV or XLSX. You can change it to an excel spreadsheet using this:

 

library(xlsx)
write.xlsx(mydata, "c:/mydata.xlsx")

 

Not a perfect solution, but might work till they add this feature.

 

Hope this helps,

 

Alan

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I don't get.. I click on "R script visual" --> copy and paste your commands by changing the destination folder bout nothing happens.. Could you please explain me how this workround works? 

     

     

     

    Thanks

    Massimo

  • mstarks's avatar
    mstarks
    Icon for Advocate I rankAdvocate I
    9 years ago

    Thank you!