Allow Power Query to Export Data

[hendustu]

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

[shannonholck]

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.

[i_feldmann]

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)

[stuartbward1]

This is a must-have feature.

[redgumbusinesss]

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! 😉

[fbcideas_migusr]

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/

[taylor6]

A MUST!!!!! Power BI would be a go to tool for all large enterprise data base management.

[AntoineCh]

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

[deepak_ibshyd]

This is a must in order to make data models more efficient.

[dave_schmidt]

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

[shaunfsx]

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!