Forum Discussion

hendustu's avatar
hendustu
Icon for Advocate I rankAdvocate I
11 years ago
Solved

Can PowerQuery write data back out?

So I know that PowerQuery is great for consuming and transforming data, but are there any export options? If not, what's the least klugey way to get data out of a BI model and into SQL tables, or a C...
  • curth's avatar
    curth
    11 years ago

    Consider making a feature request on the "Give Feedback" site.

mim's avatar
mim
Icon for Advocate V rankAdvocate V
9 years ago

another option that does not require any third party is to use powershell, i tried the vba approach and it does not work with large data, R works very well, but in some environement it may not be available

 

the script is here

 

 

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
9 years ago

This is brilliant mim !!!

Re size-limitations: Change the export-format to txt (instead of csv) and these size-limits are gone :-)

Thx a ton!