Forum Discussion
Optimizing Report Builder Performance
Hello all, I have build a paginated report in PBI Report Builder that pulls in data from a Power BI dataset, applies a filter, and then publishes a straight set of columns from the table. The pr...
pbiuser12345 wrote:
The performance is abysmal because it needs to pull in 10M records before it filters down to the relatively few records I need (<10K records).
How are you doing this filtering? If you are using the "Filters" collection in the dataset for the paginated report this could explain your issue. You should always avoid using these and use filters/parameters in query instead.