Split results into two tables

[Anonymous]

Hello,

So i have a swelf serve report on PowerBI Service that has a table consisting around 160K rows depending on what filters are applied. Now, our marketing department uses this to feed into another tool but they can't export more than 150K rows. Is there a way to split this into two tables, one having 150K rows and the other one having whatever rows are left.

Thanks

[mohammedadnant · Accepted solution]

Hi @Anonymous 

Try this workaround,

1. Add a row number as a seperate column

2. select the table visual --> in Filter pane --> select the row number column and set less then or equals to 150k

3. duplicate the table visual --> filter page --> select the row number column and set greater than 150k

by doing this you will have 2 table visual and they can export it into excel 2 times. hope this will help

Thanks & Regards,

Mohammed Adnan

Learn Power Platform for free: https://www.youtube.com/c/taik18

[Anonymous]

Hi  @Anonymous ,

You cannot split the table in power bi services, you can put forward your ideas and vote in the following link:

https://ideas.powerbi.com/ideas/

But you can filter the table in power bi services, and the exported data is the filtered data
This is the data I created:

1. Publish its report to power bi services

2. In the Filters on the right, select the filter criteria, for example, the date is 2021.1.1, 2021.1.2

3. Click Export data, File format—Excel 150000-row max

4. The exported data is filtered data

Best Regards,

Liu Yang

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