Forum Discussion

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

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

  • 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.