Forum Discussion
Exporting data from append query/report
I am trying to export the data from a report that is built from an append query of many Excel files. The export process does not export the entire data set, but only the data from the first of the many Excel files. Is there a way to export the entire appended dataset?
Hi There,
It only allows you to export first 10000 rows of your data to CSV file. For larger file exports, you can use R for that Purpose.
For more information on using R for export purposes,
Please Refer to below Blog.
http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
Thanks & Regards,
Bhavesh
4 Replies
How are you trying to export the appended dataset. Can you plese elaborate?
Thanks & Regards,
Bhavesh
I am using the Export Data feature directly from the report with the Desktop application. I am a new user, so please tell me if I am still not being specific enough.
Hi There,
It only allows you to export first 10000 rows of your data to CSV file. For larger file exports, you can use R for that Purpose.
For more information on using R for export purposes,
Please Refer to below Blog.
http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
Thanks & Regards,
Bhavesh
