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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
11 years ago

No.

 

Easiest/quickest way is to go into your PowerPivot model, select the table, Ctrl-A, Ctrl-C. Open new Excel file, Ctrl-V, save as CSV

Moh_ali_square's avatar
Moh_ali_square
Icon for Advocate II rankAdvocate II
9 years ago

Hi,

now you can right click on the table, Select copy table, and then you can past directly in Excel spreadsheet. 

 

Regards, 

Mohamed.