Allow Power Query to Export Data

[hendustu]

Allow Power Query results to be written back to a flat file or SQL table. Relivant forum thread: http://community.powerbi.com/t5/Integrations-with-Files-and/Can-PowerQuery-write-data-back-out/m-p/1747

[jrecasens]

GREAT IDEA!

[basroling]

Yep, Powerquery is my preferred ETl tool but i still revert to other ETL tools whenever i need the output in a SQL table or csv. Please add this feature.

[siebert_jm]

Yes, yes, yes.

[do1]

Power Query is an incredibly powerful ETL tool. Opening it up, so that it could be used to load data outside of Excel/Power BI/SSAS Tabular would probably make it the best ETL tool in the WORLD! This is a must!

[pbiideas1]

Great idea! Why not use the same "Transform UI" for your Datawarehouse ETL experience? And use CDS-A / Data Flows as storge. Or add Power Query to Azure Data Factory / Azure DW, ...

[fbcideas_migusr]

Well, you can run Python or R script at the end and do whatever you need (csv/excel export, write to db, etc.).

[vpournavab]

This would be amazing!!

[clf]

希望可以輸出ETL結果到 SQL Server 以作為資料倉庫使用！！

[miguel]

The path to accomplish this task is to use Dataflow Gen2 which can write a CSV or an XLSX files to a destination. 

More information about data destinations in Dataflow Gen2 can be found below:

Dataflow Gen2 data destinations and managed settings - Microsoft Fabric | Microsoft Learn