Forum Discussion
Solved
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 m...
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
I have the append quieres in power Query and need to export the data to CSV file using R script.
Could you please let me know how to achieve this?