export results of SQL query from a fabric warehouse to a flat file on a SharePoint documents library

[JWS]

Hi,

New here. My apologies in advance.

I would like to have a triggered event, for simplicity let's say every hour, I would like the contents of a specific table that exists in My Workspace in Fabric in a Data Warehouse to be exported to a .csv file in a SharePoint documents library.

I have tried to search for an answer to this, but, google queries and even asking Copilot this, possibly simple question, yields no useful results. Asking Copilot leads to it halucinating a menu tree in power automate where I should create a Sink to export my data.

Every search leads to all of the Fabric documentation about ingesting data from SharePoint into Fabric, but there does not appear to be any microsoft authored content that I can find about how to get the data OUT.

Any assist would be appreciated.

Thanks!

[lbendlin]

In Power Automate

- create a scheduled flow

- run a DAX query against a dataset (you get that automatically in the data warehouse)

- create a CSV table from the "First Table Rows"

- save the CSV to the SharePoint Document library.