Multiple datasets for large paginated report

[KimoMakano]

I have a very large report that utilized 33 separate data sets (all from the same source).

This report generates 33 pages into a single PDF file.

It takes over an hour to run, is there anyway to make it run faster?

Thanks

[KimoMakano]

Okay, I am going to try asking this differently. I have created the report and it runs file.

The report generates a list of default value parameters based on a query in the report. 

Is there a way to have each parameter value export as a separate file?

So if there are 12 values generated by the query I want to end up having 12 separate outputs generated vi Power Automate

Appreciate any assistance,

Thanks

Jim

[bradsy]

Hi KimoMakano,

I am not familiar enough with Power Automate to answer. But I would guess there is a way to export for each parameter value. This might not be what you want, but there is a feature that can send an email based off of specific parameter values. I am not sure it can be tuned to send the way you want. https://learn.microsoft.com/en-us/power-bi/collaborate-share/dynamic-subscriptions 

[v-jiewu-msft]

Hi ,

Based on the description, try to optimize the queries to select only the required columns.

Best Regards,

Wisdom Wu

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

[KimoMakano]

Thanks, I really need to find a way to automate this report.

Evidently the post below solved it but I have not been able to get any response from anybody.

Would REALLY appreciate some assistance here.

[KimoMakano]

Thanks for the quick reply.

Each data set in the report populates a different table, the each table is a separate page of the report.

We used to create this in Crystal Reports but now are required to us Power BI

[bradsy]

Better to have fewer datasets. You can have one dataset or a couple of datasets. Then for each table, filter down to the data you want. This applies to the paginated reports in the service: https://learn.microsoft.com/en-us/sql/reporting-services/report-design/add-a-filter-report-builder-a... Or at the dataset level: https://www.mssqltips.com/sqlservertip/2597/dataset-and-tablix-filtering-in-sql-server-reporting-ser...

[bradsy]

Interesting why you would need 33 different data sets from the same data source. Each dataset will query the data source, possibly with multiple connections. There might be queing or other things going on because only so many connections can be made at one time. I suggest to look at the report design and why you need that many datasets.

If there are any aggregations or filtering done in the report, consider to move those to the datasets\queries to reduce the amount of data retrieved.

Here is an article that might help. https://learn.microsoft.com/en-us/power-bi/guidance/report-paginated-data-retrieval

[KimoMakano]

Thanks for all the feedback. I do realize this is an extraordinary large number of datasets.

I may be able to pare it down to 11 but that would be the fewest.

[KimoMakano]

Thanks for  asking. 

It is a bizarre report for sure.

The report has 33 separate pdf pages, each page summarizes different aspect of data with differing columns.

It is too complex to use a single data set