Forum Discussion

hendustu's avatar
hendustu
Advocate 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
Community 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

hendustu's avatar
hendustu
Advocate I
11 years ago

Yeah, it's just that we're often dealing with very, very large datasets.

 

There's no way to pull a data model into access is there? I'd say that we could take our workbook and pull it into Tabular Services, but I don't think on-prem SQL Server can refersh Power Query.