Dynamic Rank for Export Tables

[sarhutson]

I'm not sure where to start. I have a report published on the service where users export accounting data into excel. However, they hit the 150,000 row max very quickly and it takes them some time to change the date filter or categories or even a combination of the two to get under the 150 K limit and then repeat the process for millions of records. My idea is to create up to 5 tables on one "Export" page where the first table contains rows 1-150,000 and table #2 contains rows 151,000-300,000 and so on. If the results are less than 150,000 all the data displays in the first table and the other 4 are emtpy. I tried a RANKX but I must have been doing it incorrectly because when I filter on it the values shift and I get the same rows on both tables. 

[Ritaf1983]

Hi @sarhutson 
There are a frew more effective alternatives for exporting to excel than splitting the tables, like
Analyze in excel / paginated reports.
Please refer to the linked guide:
https://www.youtube.com/watch?v=JMjdWK_imiM

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[v-menakakota]

Hi  @sarhutson  ,
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  @Ritaf1983  and @Royel , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team.

[v-bmanikante]

Hello @sarhutson,

I am also part of CST Team and we’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Regards,

B Manikanteswara Reddy

[v-menakakota]

Hi  @sarhutson ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team.

[Royel · Accepted solution]

Hi @sarhutson rather than creating multiple tables and complex solution you can try with Power BI Paginated report. The best part is it dose not have row limit and user can export any amount of rows in pixel perfect format.  

You can start from here: 

Get started creating paginated reports in the Power BI service

Is it helped? ✔ Give a Kudo • Mark as Solution – help others too!