Missing rows in paginated report

Greetings,

I have created paginated sales report for previous week. I filter 2M row dataset in query builder with date and client filters. It works perfectly.

When I try to replicate this approach to report for previous month I get missing orderlines. For example in Power BI dashboard with a same dataset I can see 6 orders, but in Paginated Report I see only 4 orders (5 orderlines). Sales on 2023-03-15 and afterwards are missing.