HELP! How to add paging in power bi desktop report

[TheTeam35]

Hello,

I want to add a paging bar to my desktop report. (I use DirectQuery btw.)

Because my report has more than 20k rows.

I found this solution but it doesn't support the DirectQuery mode.

https://www.fourmoo.com/2017/10/31/power-bi-how-to-do-pagination-in-power-bi-reports/

Do you have any ideas?

Is it possible?

Thanks.

Erdem

[v-stephen-msft · Accepted solution]

Hi @TheTeam35 ,

Try this video tutorial:

Power BI - Visual Pagination - YouTube

Some of the dax functions inside are allowed to be created under DQ (for measures).

Best Regards,

Stephen Tao

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

[TheTeam35]

Any idea?