Skip to main content

Power BI

Needs Votes

Allow Power Query to Export Data

Vote (830) Share
Henson's profile image

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)
Henson's profile image Profile Picture

Dave Schmidt on 05 Jul 2020 22:18:12

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

Henson's profile image Profile Picture

Antoine Chamba on 05 Jul 2020 22:14:50

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

Henson's profile image Profile Picture

Power BI User on 05 Jul 2020 22:14:43

RE: Allow Power Query to Export Data

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

Henson's profile image Profile Picture

Imke Feldmann on 05 Jul 2020 22:12:55

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/

Henson's profile image Profile Picture

Peter Schmidt on 05 Jul 2020 22:10:26

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

Henson's profile image Profile Picture

Stuart Ward on 05 Jul 2020 22:09:05

RE: Allow Power Query to Export Data

This is a must-have feature.

Henson's profile image Profile Picture

Imke Feldmann on 05 Jul 2020 22:09:05

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)

Henson's profile image Profile Picture

Shannon Holck on 05 Jul 2020 22:04:25

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.