Issue with "Fetching Data" in Power BI Paginated Report

[LisanneIsAsking]

Hello everyone,

I am currently working on a Power BI Paginated Report. I have built this report with a selection filter. For example, you need to select a project first before accessing more information.

Once you make a selection and click the "View Report" button, the screen shows "Fetching data" (see the attached image). The row count keeps increasing to a large number, but I don’t end up seeing the data.

Does anyone know what might be going wrong here?

Looking forward to your help, and thank you in advance!

Kind regards,

Lisanne

[MikePolamalu43]

I have the same issue. Paginated report is fetching tens of milions of rows and I get about two hundred of them.

I've applied multiple filters in query, which returns the appropriate amount of data, however I'm trying to find out why the paginated report is "fetching" so much and how can I fix this - I'm not sure how to deal with parameters as we cannot use them with fields

I'd really appreciate your help guys!

[R1k91]

which is your sorce? SQL? Analisys Services? Power BI?

are you using parameters or filters?
you should verify if you filter is folding to the source. 

filters are executed after data is retrived Filter, group, and sort data in Power BI paginated reports - Power BI | Microsoft Learn

[MikePolamalu43]

I'm using PBI data source (workspace usage report)

I've created a query that filters out rows with 0's for report page views and defined date range to minimize the load. I've applied those filters on dataset level and page level, with the same result. Not sure what to do with parameters though

[MikePolamalu43]

I'm using powerbi data (workspace usage stats to be precise). I used filters on a dataset level as well as on table level. I tried to create a parameter but it prevents me to use objects in parameters. Not sure what else to do 

[divyed]

Hello @LisanneIsAsking ,

This shows your query is running and fetching rows . Can you elaborate more about your dataset or query you are using and how much data you are expecting . Looks like you are trying to fetch large data . There are many option you can check/utilize :

1. Try to reduce data volume by appying query filters.

2. Your query looks slow, try to optimize query 

3. Check your output first using SSMS or any other tool to make sure you are fetching required data . Recheck your joins , filters etc.

4. Use aggregations to reduce the dataset size.

I hope I answered the question. Mark this as solution if this helps, Kudos are appreciated.

Linkedin : https://www.linkedin.com/in/neeraj-kumar-62246b26/

Cheers

[hackcrr]

Hi, @LisanneIsAsking 

You're loading too much data, resulting in data freezing.
You should try to implement query parameters for your paginated report or try to use parameters to filter out a subset of the data instead of loading it all at once.

Best Regards,

hackcrr

[R1k91]

it means the query you're running on the backend system is fetching those rows.

which is the query you're running? are you sure you filtered the dataset by parameter?