750
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
STATUS DETAILS
Needs Votes

Comments

H

This would be amazing!!

H

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

H

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, ...

H

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!

H

Yes, yes, yes.

H

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.

H

GREAT IDEA!

H

PowerBI (and Power Query) is getting very close to Killer App status. This would move it along that pathway significantly. There is limited use in a tool that can take data from almost anywhere, perform almost any transformation and then not externalise the result. Note that a lot of other suggestions on this site also arguably would be satisfied by taking this on - and so I feel this feature is under-represented in vote count.

H

For those interested, this blog shows how to do this with PowerShell, really straightforward, works great even with large data. https://ruiromanoblog.wordpress.com/2016/04/21/use-power-bi-desktop-as-an-etl-tool/

H

Can't wait!!!!!