Paginated Report

Hello everyone. Currently, I am working on the creation of a paginated report based on a power bi report.

Initially, I used a PowerBi DatasetConnection( premium workspace). During the working process, I realized it is abnormal to take so much time to execute a few queries or add 2 parameters. However, I decided to connect to the MySQL database, the process was fast but the added parameters are not changing the content when applied. Have you ever encountered such issues?