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

[CalvinEClack]

As with others, we think PowerBI can be the silver bullet, the BI slayer, if it writes back data to SQL Server.

[mimoune_djoual1]

I use dax studio as a workaround, using dax query and export to a text file, i have test it with a 3 Million records and it works very well

[frenk_vanbeekv1]

As a bit of a workaround, the method described here: http://biinsight.com/connect-to-power-bi-desktop-model-from-excel-and-ssms/ also works to connect SSIS to Power BI Desktop.

[smorton]

must have for enterprise solution

[bac282]

this needs to happen! especially for large datasets (> 1M)

[SaythJWRenshaw]

Great idea can't wait to see it.

[kgeesawor]

Absolutely - Is this possible?

[michael_colber1]

Can't wait!!!!!

[kthejoker]

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/

[challenge_addic]

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.