Paginated report and DB2

Power BI report builder to DB2- Built a report with dataset parameters and limiting data to just 100 records even then the performance is really bad any suggestions .