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 (26)
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.
RE: Allow Power Query to Export Data
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!
RE: Allow Power Query to Export Data
This is a must in order to make data models more efficient.
RE: Allow Power Query to Export Data
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!!!
RE: Allow Power Query to Export Data
'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).