Export/Split data from DataModel to sheets

Hello,

I have a data model in Excel with a couple dozen tabs, some of which have a couple million rows.

What I am trying to do it move a table with 5 million rows, lets call it "InvoiceTable", into 20 different tabs, named InvoiceTable-1, InvoiceTable-2, InvoiceTable-3, and so on, each with 250k rows. I need to split them because Excel gets cranky when you try to post 5M rows into one tab.

The way I think this will work is if I create a simple helper column in each table where row count will be an issue, something to the effect of =INT(ROW()/250000), and use that as the split-point and also as a value to concatenate onto the resulting tab names so there are no duplicate tabs.

My question is; how would I go about Exporting tabs of data in DataModel into Excel sheets, while splitting them by the value I create with the formula?


Thanks!

marked as solved - I found another simpler way to do this. for anyone else looking to export data models into csv - I'm using DaxStudio with a simple EVALUATE TABLE_NAME query and using results to file as the output. Easy!