cancel
Showing results for 
Search instead for 
Did you mean: 
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 Datanaut!




9 REPLIES 9
Super User IV
Super User IV

Re: Export Data --- Now available?

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


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

Putting square pegs in round holes since 1972.

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 Datanaut!

agenovese
Frequent Visitor

Re: Export Data --- Now available?

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

kcantor Community Champion
Community Champion

Re: Export Data --- Now available?

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 Datanaut!




agenovese
Frequent Visitor

Re: Export Data --- Now available?

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.

HarrisMalik Continued Contributor
Continued Contributor

Re: Export Data --- Now available?

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

AndrewDang Helper IV
Helper IV

Re: Export Data --- Now available?

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


Thanks;

Andrew

 

AndrewDang Helper IV
Helper IV

Re: Export Data --- Now available?

@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

kcantor Community Champion
Community Champion

Re: Export Data --- Now available?

@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 Datanaut!




AndrewDang Helper IV
Helper IV

Re: Export Data --- Now available?

@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
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.