Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |