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 (28)
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).
RE: Allow Power Query to Export Data
A MUST!!!!! Power BI would be a go to tool for all large enterprise data base management.
RE: Allow Power Query to Export Data
With the December update you can use the workaround via R to export your data from Power BI to txt or SQL-server: http://www.thebiccountant.com/2015/12/28/how-to-export-data-from-power-bi-and-power-query/
RE: Allow Power Query to Export Data
You can do this with a small amount of VBA and a calculated column that incorporates an INSERT statement. Load the data into an Excel worksheet then iterate down each row executing the INSERT statement. Would be good if you could specify a database and table as a destination though! ;)
RE: Allow Power Query to Export Data
This is a must-have feature.
RE: Allow Power Query to Export Data
In order to avoid constant queries to the underlying datasources (like ERP-systems) for performance reasons, it would be great if one could save the results of the basic-cleanup steps in a csv-file which would then serve as the basis for all monthly reports. (“Lightweight DWH” without server, single point of truth)
RE: Allow Power Query to Export Data
This is one of the first things I wanted to be able to do. I imported data from the web, but it is dirty. I want to map the values to human readable ones and then reimport it, but I can't export the data directly from Power BI Desktop.