Exporting/Copying Back to Excel

[jamescooper]

I have many large csv files with data now combined via the append query tool. How do I now get this data back into excel please?

Thanks.

 

[Matt Allington]

Do you mean you are using Power Query? Right click on the query, select Close and Load To and then select Table

 

[jamescooper]

Hello mate, ive loaded all the data into the power bi desktop, do i do it from in there?

 

[Matt Allington]

So you are using power bi desktop? Mmm, that is a problem then. maybe you could use DAX studio. It will definitely connect to power bi desktop. What I am not sure is if you can send the output to Excel. You definitely can when querying an excel workbook.

I wrote a blog a while back about it. DAX Studio 2.0 released today -

 

[ImkeF]

Hey Matt,
this is absolutely awesome! You can send the results to txt and open it with xls. Which is much better than xls, because it doesn't have any row limits!
So this is also a workaround to export your PQ results from Excel that contain more than 1,1 Mio rows somewhere else than the internal data model.
I know that many people are looking for this option, so you should spread the word and make this a blogpost!

EVALUATE(SUMMARZIE(YOURTABLE, [Columns...]))