Forum Discussion
Helper ITable Visual unable to load data despite having fewer rows.
Helper IHi,
The DAX query is taking 225934ms for this table. But the query for both the tables is the same. Another thing is as soon as I remove the pagination filter from the table, it is rendering fine. The pagination filter(which restricts the amount of items displayed on the page). Also the table is rendering the data if I limit the amount of rows to top 5000.
Super UserHi,
It looks like the pagination filter is impacting performance. Since removing it allows the table to render and limiting rows to 5000 works, the issue might be how the filter interacts with the dataset. Even if the DAX query is the same, Power BI could be handling rendering differently due to filters. Try checking how the pagination filter is applied, whether it adds extra processing, and if the query can be optimized. Running the Performance Analyzer while toggling the filter might give more insights. Let me know what you find!
- SaiK
The pagination filter is seperate for both the tables. The Table A filter is working fine and rendering the data. Whereas the Table B filter is causing issue becasue if I remove the filter, then the entire data is displayed without the top N 5000 filter too. In case of pagination for the Table B it isworking only if the TOP N is set to not more than 5000
- Bibiano_Geraldo
There's way to share no sensitive file? To see closer what causes this loss in performance
- SaiK
It's tough because it has sensitive company data. But for reference this is the video I referred to build the pagination in my table. UX Revolution with Visual Level PAGINATION in Power BI