Forum Discussion
Is it possible multiple output files in Power query?
I usually use Power Query inside Excel. Power query can use as an input many excel worbooks or tabs but I have not seen the reverse. i.e. any way to create as an output many workbooks or tabs from just one query. There's no M function "save query output as an Excel file".
The final transformations of my query are many filters in a column, and the output of each filter must be in a file in order to be emailed. When "close and load" you only generate one file...
Do you suggest any idea to accomplish this task? Many thanks in advance.
Maybe I could carry out the filters further with VBA... I wouldn't like a solution as to use R in Power Query, but I'm afraid it is the only solution. I would love to do all in Power Query!
Anonymous
It is not possible to do this. You could have a VBA routine from within Excel to refresh the queries and then save them.
3 Replies
- LivioLanzo
Solution Sage
Anonymous
It is not possible to do this. You could have a VBA routine from within Excel to refresh the queries and then save them.
Thank you for the answer and the link!! But just in one of the comments on the Chris Webb page you sent to me there is a link with this suggestion "Export PowerQuery query to CSV" https://excel.city/2018/06/export-powerquery-query-to-csv/ I wonder if it works and why it depends of the IE settings.