Exporting a table with over 1 million rows

[ttpcap]

I have a table with 1.6m rows in Power BI and I want to export it in two separate files of 800k rows each to Excel - how do I do this?

[v-yiruan-msft · Accepted solution]

Hi @ttpcap ,

You can refer the methods in following blogs to achieve it:

Export large amount of data from Power BI desktop visuals

Performance analyzer pane to export all data of a visual

Best Regards

Rena

[Mariusz]

Hi @ttpcap 

You can use DAX studio.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn