Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
kcantor
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
agenovese
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.

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

 

Greg_Deckler
Super User
Super User

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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors