Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
We have a tabular model and at times we would display some rows via matrix or table, due to the large amount of rows, is there some way to only display for eg. 5000 rows on a table, and have a next button to show the next 5000 rows instead of displaying everything which I doubt will have a enough memory for the visual to display?
Solved! Go to Solution.
Hi, in order to paginate I would recomend this:
Regards!
Hi @vilenm ,
After you create an index column in power query, you can create a custom column like this as @ jbocachica mentioned(in my sample, use 20 as the base for paging):
Close & apply it in power query, use the custom column as the filter that you could get the expected result.
Attached a sample file in the below, hopes it could help.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, in order to paginate I would recomend this:
Regards!
Hi John
Thanks this can work! . How would I implement point 2 and 3 ? maybe example?
thanks
Hi @vilenm ,
After you create an index column in power query, you can create a custom column like this as @ jbocachica mentioned(in my sample, use 20 as the base for paging):
Close & apply it in power query, use the custom column as the filter that you could get the expected result.
Attached a sample file in the below, hopes it could help.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |