Forum Discussion

mstarks's avatar
mstarks
Advocate 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...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi mstarks,

The ability to get report snapshots emailed to you on a recurring schedule is already available :-)  See this article:

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-subscribe-to-report/

 

And you can also already export the data behind the visualizations.  See this article:

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-export-data/

 

I'm adding more info to the last article this week, so please revisit the article in a few days when the updates go live.

 

- Michele

 

mstarks's avatar
mstarks
Advocate I
9 years ago

I use the export to Excel quite often - it's extremely helpful.  I'm wondering, however, if there is a way to set it up so the data is automatically exported to an excel file on a daily basis and distributed via email, much like the report snapshots.  Is this possible?

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago
    mstarks wrote:

    I use the export to Excel quite often - it's extremely helpful.  I'm wondering, however, if there is a way to set it up so the data is automatically exported to an excel file on a daily basis and distributed via email, much like the report snapshots.  Is this possible?

    Thanks!

    Hi mstarks,

    An idea about automatically exporting data on different time basis has been submitted in the following link, please vote it up and you can add comments in this idea.
    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13832208-auto-scheduled-export-of-data

    Thanks,
    Lydia Zhang

    • alanhodgson's avatar
      alanhodgson
      Solution 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