Dataflows Gen2 - data destinations

[Dimitri_Backae1]

When it comes to data destinations, today we already have some great options to use, ... but, wouldn't it be great if a simple text file output (*.txt, *.csv, ...) was added to the list? 

I can think of some (data dumping) scenario's, where citizen users want to export the results of their dataflow for future use.

Is this something which might be put on the roadmap?

[nishalit]

Planned for CY2024

[jesse_stratton]

Is there any way to get my data out of my data Warehouse?

SSMS had the option to send results to a file.

An end point for the dataflow to be a flat file on a SharePoint location would be great.

In the meantime, I have a lovely dataset that I can't use because the data can't escape the warehouse.

@dimitri, do you have a workaround you currently use that you'd be willing to share?

[fbcideas_migusr]

Hi Jesse,

Apologies for the late response.

Unfortunately, until today, I don't have a workaround.

[miguel]

Today, you can save a .csv file in a SharePoint site or even in your own Lakehouse. You can read more about the current data destination capabilities from the link below:

https://learn.microsoft.com/en-us/fabric/data-factory/dataflow-gen2-data-destinations-and-managed-se...