How to Export more than 10 million rows from Power query in power BI

[Apjeri]

Atempted this method from a previous post, also unable to copy the table due to the amount of rows in the cleaned data set.

[danextian]

Hi @Apjeri 

It is possible with DAX Studio on a data that's been loaded to the model but there's a but. You'll be limited to the specs of your device. Exporting data from the model requires the data to be materialized and that will eat up on you memory. I attempted to export data from a model with over 340 million rows and six columns and it was unsuccessful. I had to export it at around 3.5M rows at a time.

[Apjeri]

Actually this would be best as after running a find and replace for incorrect or misspelled values is still running more than 30 minutes later. 

How do I seperate almost 11 million rows?

[tharunkumarRTK]

@Apjeri 

If you want to export more than 30000 rows from desktop then you need use external tools like DAX studio or Bravo etc. 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[pallavi_r · Accepted solution]

Hi @Apjeri 

Can you please try export using Dax Studio as in this link -  https://www.youtube.com/watch?v=op6f-3uUFYg

If this post helps, please accept this as a solution. Appreciate your kudos.

Thanks,

Pallavi

[Apjeri]

This worked to export all 11million rows, Thank You!