Power Query Outputs to Excel, CSV, Etc.

[learning_dax]

Hi all,

I'm having a rough time understanding how I turn complex Power Query workflows into CSVs, Excel Files, and store those in different folders etc. I know Alteryx, Knime, Tableau Prep, & others have "Output" steps they can add that turns the steps into a table and can store it in a File. Thus, they can schedule the flow to run and end up with a file stored somewhere. I love Power Query and all it can do, but find it limiting that I can only then create a connection of my query to PBI desktop. 

I only say this because I want to establish refresh-able & automated workflows that I can click once, the power query steps will run, and then dump that query into a folder I want it to. This is possible with Tableau Prep, Alteryx, & Knime but I love the PQ interface & integrations. Any help on how I can achieve this?

[ams1]

Hi @learning_dax 

You mean something like:

• https://blog.crossjoin.co.uk/2018/09/26/using-power-query-and-microsoft-flow-to-automate-the-creatio...
• https://learn.microsoft.com/en-us/azure/data-factory/control-flow-power-query-activity

?