cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mstarks Frequent Visitor
Frequent Visitor

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 table chart into excel (rather than snapshot) so the data could be manipulated by the end-user?

 

Thanks for your insight!

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft mihart
Microsoft

Re: auto export of data

@mstarks

Not yet!  But suggest it as an idea (or see if someone else has already suggested it).

 

https://ideas.powerbi.com/forums/265200-power-bi

 

- Michele

View solution in original post

7 REPLIES 7
Microsoft mihart
Microsoft

Re: auto export of data

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 Frequent Visitor
Frequent Visitor

Re: auto export of data

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!

Microsoft mihart
Microsoft

Re: auto export of data

@mstarks

Not yet!  But suggest it as an idea (or see if someone else has already suggested it).

 

https://ideas.powerbi.com/forums/265200-power-bi

 

- Michele

View solution in original post

alanhodgson Established Member
Established Member

Re: auto export of data

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

Moderator v-yuezhe-msft
Moderator

Re: auto export of data


@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...

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mstarks Frequent Visitor
Frequent Visitor

Re: auto export of data

Thank you!

Anonymous
Not applicable

Re: auto export of data

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? 

 

problem.png

 

 

Thanks

Massimo

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)