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?
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.
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?
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?
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.
We are excited to announce the Power BI Super Users!
Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.