scheduled output of dataflow to csv on OneDrive

[zenaxman]

I am wondering if there is a way within the service alone, perhaps using Power Automate, to take the output of a query within a dataflow (or published as a dataset), and write it to a csv file (or similar) triggered by the dataflow refresh.  Thanks in advance.

[bcdobbs]

Not sure if it is inside your requirement for "inside service alone" however easiest way is to tell dataflows to use you own azure data lake stoarage:
Create a storage account for Azure Data Lake Storage Gen2 | Microsoft Docs
Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Docs

When a dataflow runs it normally stores data in csvs in hidden data lake storage. The above just exposes it.