Henson on 31 Jul 2015 22:00:34
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
- Comments (30)
RE: Allow Power Query to Export Data
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.
RE: Allow Power Query to Export Data
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/
RE: Allow Power Query to Export Data
Can't wait!!!!!
RE: Allow Power Query to Export Data
Absolutely - Is this possible?
RE: Allow Power Query to Export Data
Great idea can't wait to see it.
RE: Allow Power Query to Export Data
this needs to happen! especially for large datasets (> 1M)
RE: Allow Power Query to Export Data
must have for enterprise solution
RE: Allow Power Query to Export Data
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
RE: Allow Power Query to Export Data
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.
RE: Allow Power Query to Export Data
As with others, we think PowerBI can be the silver bullet, the BI slayer, if it writes back data to SQL Server.