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 a...
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

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