Exporting data from append query/report

[becca]

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?

[Anonymous]

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?

[BhaveshPatel]

How are you trying to export the appended dataset. Can you plese elaborate?

Thanks & Regards,

Bhavesh

[becca]

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.

[BhaveshPatel · Accepted solution]

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