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
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.