Forum Discussion
Multiple datasets for large paginated report
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
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.