Allow Power Query to Export Data
Allow Power Query results to be written back to a flat file or SQL table.
Well, you can run Python or R script at the end and do whatever you need (csv/excel export, write to db, etc.).
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, ...
Daniel Otykier commented
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!
Yes, yes, yes.
Sebastian Roling commented
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.
Javier Recasens commented
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.
Kyle Hale commented
For those interested, this blog shows how to do this with PowerShell, really straightforward, works great even with large data.
Kushal Geesawor commented
Absolutely - Is this possible?
Great idea can't wait to see it.
this needs to happen! especially for large datasets (> 1M)
must have for enterprise solution
Mimoune Djouallah commented
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
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.
As with others, we think PowerBI can be the silver bullet, the BI slayer, if it writes back data to SQL Server.
Shaun Loughlin commented
This is a must have function for me. Power BI is so close to being my complete data management solution but if I can't get the data back out then it's impossible!
Deepak Agrawal commented
This is a must in order to make data models more efficient.
Dave Schmidt commented
This is a definite need. As others note, there are workarounds but they are really only effective with a small amount of data. Being able to easily export data (especially into a flat file format) is often requested by my users and would be a very welcomed enhancement!!!
Antoine Chamba commented
Yes, this would make it way more versatile.
For now you can export it to PPivot, and either:
- Copy paste it into excel (small volumes, but anything within bare excel limitations with a good enough computer)
- Use a macro to dump it into a csv. It crashes with large volumes though (> 5-10 Go).