How Optimize the direct query in paginated repots with huge data in tabular form? Any alternative?

[Padmakar]

How optimize the direct query in paginated repots with huge data in tabular form? Any alternative for showing the huge amount of data through direct query in tabular form with slicers selctions. Is there a possibility of having drillthrough from normal powerbi report to paginaged report.

[amitchandak]

@Padmakar , you can use a power bi dataset in the paginated report, do try if you can use a direct query dataset there.

You can add paginated report as visual in power bi report