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

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

RE: Allow Power Query to Export Data

Can't wait!!!!!

Henson's profile image Profile Picture

Kushal Geesawor on 05 Jul 2020 22:42:23

RE: Allow Power Query to Export Data

Absolutely - Is this possible?

Henson's profile image Profile Picture

Sayth on 05 Jul 2020 22:37:29

RE: Allow Power Query to Export Data

Great idea can't wait to see it.

Henson's profile image Profile Picture

BA on 05 Jul 2020 22:36:53

RE: Allow Power Query to Export Data

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

Henson's profile image Profile Picture

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

RE: Allow Power Query to Export Data

must have for enterprise solution

Henson's profile image Profile Picture

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

Henson's profile image Profile Picture

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.

Henson's profile image Profile Picture

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.

Henson's profile image Profile Picture

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!

Henson's profile image Profile Picture

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.