cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Community Champion
Community Champion

Export Data --- Now available?

Just found an Export button on my report tiles this morning. Haven't seen the update blog yet but when I clicked it, it exported to EXCEL!

Anyone else notice this?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




9 REPLIES 9
Frequent Visitor

Looks like it is the chart data(aggregated date) in CSV format, not the drill down.

It may not be drill down but it sure is a start in the right direction! And, mine exported to Excel when I requested Excel.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Oh for sure! I am super excited about it, just wanted to see if people had what I saw.

 

The email went out to my CFO immediately about this, he has been waiting for the export to CSV function before signing the company up with pro accounts.

Continued Contributor
Continued Contributor

The aggregated data from dashboard tiles and report visuals is nicely exported in CSV format. Great.

It looks like it is limits to 10K rows of data only. Does it sound correct?


Thanks;

Andrew

 

Super User IV
Super User IV

If you are referring to the ellipses | Export data, yeah, I just found that based on your post.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@Greg_Deckler

@kcantor

@HarrisMalik

@agenovese

 

 

I seems to have more data when i use the export feature than i expected.  for example, I have a data set of 3185 records, i then have 3654 records when i export it to excel.  I have another set of 4886 records in excel, and it came out to 5853 records when i export to excel.  It does not seem to make sense to me.  Did you know the reason why would this happened?

 

Thanks;

Andrew

@AndrewDang

I did a quick experiment but mine did not really increase in quantity. Of course, I used smaller visuals and matrix tables. I had the same number of rows when the header was taken into account. For my graphs, there were several 'header rows' but the matrix only added one.

What kind of visual are you exporting the data behind?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@kcantor

 

Thanks for getting back to me quickly.  I have to clarify that I am using Desktop version and Table chart. I believe that this is still raw data.  I had joined data from multiple tables.  I am hoping to have the same number of records shown on my table chart when i export it to excel.

 

Let me know if you have any question and thanks for your help.

 

Andrew

 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors