cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User III
Super User III

Export results from query editor

Hi all,

I have a number of files that I import into the query editor and then process. I would like to save the final result into external files (csv for instance or another format) so that the processed tables can be used elsewhere. This can be done if you create a table visual with all the elements of the table; you then have the option of exporting into csv. I'd like though something less time-consuming, more automated. There is an easy way to import all the files from a folder in the query editor. I am looking for something similar but in the opposite direction.  

Is there anything like that available? Any other approach you can think of? 

Many thanks for your time.

2 REPLIES 2
Highlighted
Super User IV
Super User IV

Re: Export results from query editor

@AlB may be use the same power query in excel and then save result of excel file in csv, or in PowerBI, I think with R code you can export to csv.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Super User IV
Super User IV

Re: Export results from query editor

@AlB this post might help.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors