Power BI

Needs Votes

Allow Power Query to Export Data

Vote (830)

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)

Comments (28)

Power BI User on 05 Jul 2020 22:45:07

RE: Allow Power Query to Export Data

Can't wait!!!!!

Kushal Geesawor on 05 Jul 2020 22:42:23

RE: Allow Power Query to Export Data

Absolutely - Is this possible?

Sayth on 05 Jul 2020 22:37:29

RE: Allow Power Query to Export Data

Great idea can't wait to see it.

BA on 05 Jul 2020 22:36:53

RE: Allow Power Query to Export Data

this needs to happen! especially for large datasets (> 1M)

Power BI User on 05 Jul 2020 22:29:05

RE: Allow Power Query to Export Data

must have for enterprise solution

Mimoune Djouallah on 05 Jul 2020 22:25:59

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

Frenk on 05 Jul 2020 22:25:26

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.

Power BI User on 05 Jul 2020 22:24:57

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.

Shaun Loughlin on 05 Jul 2020 22:20:22

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!

Deepak Agrawal on 05 Jul 2020 22:18:44

RE: Allow Power Query to Export Data

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