Power Query Outputs to Excel, CSV, Etc.

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?