Forum Discussion
Helper IIHow can we achieve dynamic data loading in table visual to get continuous scrolling like experience?
I have created a table visual using two tables. This visual has more than a million rows. But I don't want to load all the million rows right at the go. I want the visual to load first 100 rows when the user opens the report and then the next 100 when he scrolls to the end of those 100 rows and so on, giving a continuous scrolling like experience to the user. Can this be achieved? In my organization we are not allowed to use any visual which is not developed by Microsoft, so that is also not an option. Please help.
Hi Pp110784 ,
I'm afraid that it is not possible to implement a truly “infinite scroll” or dynamic row loading experience in a table visual. The best approach is to rethink the data presentation so that users do not have to interact with a million rows simultaneously—whether through filtering, drill down, or summarization techniques. You can consider the following alternatives:
- Connect the data source with DirectQuery mode: If your data source supports DirectQuery (e.g., SQL Server), Power BI can dynamically fetch data as users interact with the report. While not true infinite scrolling, it optimizes performance by loading only the required data for the current view.
- Prefilter or aggregate the data so that you are not attempting to display a million rows at once. For example, if you’re able to incorporate slicers or page navigators, you might allow users to drill down to a smaller subset of data.
- Configure Incremental refresh: Using incremental refresh for datasets can help with performance by limiting the data that gets processed on refresh, but it does not change the behavior of the visual in terms of scrolling and lazy-loading.
Best Regards
6 Replies
From my experience this behavior is by default. Just that there is no configuration of how many row to display initially. and in each scroll. (should be 500 from this link: Apply data point limits and strategies by visual type - Power BI | Microsoft Learn)
You can try using sample data with like 10000 rows and display it in a table/ matrix visual.
Thanks,
Lewis
- ray_aramburo
Super User
Are the ones that are not developed by Microsoft but have their verification (blue check) even allowed? If that's the case use the Grid visual by MAQ. Otherwise, I don't think there's any other way you can achieve your requirement because the standard visuals load all the data before displaying the visual.
Pp110784Unfortunately even those are not allowed. I did see this grid visual. It would have been perfect for my use case, but my organization's Power BI admin team said no to that also :(.
- ray_aramburo
Bummer 😞 An alternative I can think is to add an Index column to your table and then create multiple charts by filtering the indexes (from 1-100, 101-200, ...) and displaying them with bookmarks so users can pick the "page".
