Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Split results into two tables

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

Need Help
  • mohammedadnant's avatar
    mohammedadnant
    5 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.

  • mohammedadnant's avatar
    mohammedadnant
    Impactful Individual
    5 years ago

    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